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

Appending GET data with form submition
Okay, what I'm trying to do is to use a form to append an already existing GET data string.

I

IS this code correct
The reason i ask is everything underneath it appears to be alink as well, tis blimmin annoying

How to update this array?
I am saving a string that looks this: username1, username2, username3...
into a single cell in a

An odd assignment statement. Can someone explain this assignment to me?
What purpose is served by the bit of code between the two equal signs in the $installurl set? Is th

Multi Level Array Problem
hi all,

For example I have array like below:

$temp = array(array('north america', 'us'

php or sql?
Sorry not sure if this is a sql problem or php the following code is supposed to delete data from th

LinkedList help
Ok so I just learned quickly about lists, so I have a not too hard project I think, but am having a

how to transport the Query and insfoset
Hi

I have created the query using SQ01........
How to created T-code for query..

"GROUP BY" in arrays
Well i'm looking to do something i usually could do easily using COUNT and GROUP BY if it was a sql

Where am I going wrong
Been trying to work this out for hours

I have two tables called 'Genres' and 'Films'. Genre