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

Mysql error message
help me find out what this error message means:

"Duplicate entry '0' for key 'PRIMARY'&q

Do not allow posting of whitespace
Currently the script below works if the user does not type a name/message, but if i create a whitesp

Please Help my PHP Dating Function.
Hi everyone!

Well here is my code that displays this:

It works wonderful.

i want run some web server under the ip sharer
hello i want run some web server under the ip sharer
my ip is floating ip but it doesnt matter

Can I call a class inside a function?
I have a class written in another file that handles my image resizing.

Can I do this (php say

HELP with mysql_real_escape_string
I'm looking to remove apostrophes completely when someone enters lyrics but don't have a clue how to

Timer control causing error
I recently decided to add a timer control to an existing page that uses AJAX on my site. As soon as

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

Need help urgant
why down my code ony return one item instead of all the items selected.

$arr = array($date,$

Linked Keywords
I am trying to get a script that makes my predefined keyword converted to links and / or converted t