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

FTP issues
Hi all,


I am currently facing some serious problems with a script and really need some ad

Casting Decimals in Oracle
This code worked as a query in DB2, but I am not sure what the syntax is for casting decimals in Ora

Delete all files in folder except with certain name
I have a script that I want to delete all files in a folder (taken from a database) except for one n

need a script for 3 pages
I have a customer who wants me to set up a site with a number of pages with the following requiremen

Generating unique numbers using php
Hi,
I need help in generating unique number using php.I tired using rand() in php.But, by using r

Multi Level Array Problem
hi all,

For example I have array like below:

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

try catch error
I have been trying try catch but, I can't get it to work. The code opens a non existing file called

PHP Array quick help
I need

$_SESSION{'username'} to be like this:


if $_SESSION['username'] = "gay

Function
How can I make this function that once you click the link in the code it takes you to a new page wit

why preg_match_all does not return the number of matches
My regex looks like

X[^x{4e00}-x{9fa5}]*Y

(where X and Y are two Chinese characters)