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

registration form
first time posting. did some searches but didnt find exactly what i am looking for. dont flame cause

user administration
Dear @all,

what I have to do to set the user defaults for new users. At the moment I woul

mysql UNION | warning mysql_fetch_array !!
Code: <?php
$i = 0;
$query1="SELECT * FROM `products` WHERE `div

InternetOpenUrl() Invalid cert
Hi all,

Does anyone know how to prevent calls to InternetOpenUrl() from failing with erro

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

How to show next and prev records
Hi all,

Sorry if this is simple, i'm very new to php, well, any programming language actually

Navigation include for all site directories
Hi,

I need a navigation include that can deal with directories at different levels on a site.

PHP Search Issue
Hi, I am using the following code to search and return flights from a database. The user searches by

Need help with some php code :)
Hey! I'm quite new to this whole thing, so please don't fire me with shait on this one =D

I'm