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

form submit at godaddy?
Trying to test form submission at GoDaddy and it does not seem to work. Here's the page...

h

utf8_general_ci error ??
I have all kinds of data to be inserted in database table

//I am getting this error

Yo

Sending CC Info by email
I am a little bit less knowledgable in the security area as most developers and I know I have a lot

Procedural to OOP
John Kleijn said that to avoid writing "crappy code", we should learn OOP and common OO pr

user data not transferring to new page
I'm a PHP learner. After an index.php page, the user goes to a login.php page. Both pages seem to

insert quotes
Hi,

I have an output like this:
Code: john,18,Cancer
How can I change this to
Code:

image upload, resize THEN submit form
Ok so I have a form that requires the user to upload an image, and then do something with that image

captcha error
I have been trying to implement a captcha in php...

here is the code..
Code: (php) [Select

multiple recipients + dbuser mail recall
Hello,

I am building a php login script.

When the user registers the script will send

Return X values where an ID number doesnt matter
Well as for subject heading, thats the best i could think of.

Currently im having a problem w