HOW to get the bind variables list.

Posted on 16th Feb 2014 07:03 pm by admin

I've the following problem : I've some SQL queries stored in my DB as VARCHAR2 values.
I need to use DBMS_SQL in order to execute them.
In theese SQL statements I have some bind variables like :NUMORD. (ex. SELECT 'X' FROM YYYY WHERE FIELD_1 = :NUMORD).
I don't know "a priori" names and number of such variables.
Is there any way to have a list of such bind variables ?
I found DBMS_DESCRIBE but is seems to act only on stored procedures/functions.
I know I can tray to inspect the code looking for every ':' but a cleaner solution woulf be appreciated.
Tks

Your Answer:

Login to answer

Other forums

str_replace help
I am thinking str_replace is my only option to filter outputs from my database to convert them to sa

Display a default image
I am trying to display generic image for items that don't have one, but I can't get it to display.

Reduce redundancies in switch functions?
Hello all! I somewhat new to PHP, and was wondering if anyone could give some suggestions on a swit

Generate PDF
Hi guys,

I would like to know if there is a way to generate pdf when clicking on a link. In f

Really need helps regarding Pagination with Sort
I need someone helps regarding pagination problem...i actually want to make my page limited to let s

foreach help.
Hello all,

First time I'm attempting to use a foreach statement and was just wondering if my

Problem with HTML form
Hello,

I made a HTML form with some fields and check box.
Everything works fine except whe

Parse error: syntax error, unexpected $end in
hello,
i receive the error :Parse error: syntax error, unexpected $end in C:xamppxampphtdocsh

Xacute search within SQL results
I have a query that is pulling data, and I want to return a specific value from the results of that

Web Application Recipe
Hi Guys!

I am working with the Web Application recipes. I am currently working on the sen