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

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

FFmpeg Images 2 Video conversion problem ??
I got folder full of images , number of images = 600 , I want to make a video which plays one image

MySQL query problem
When I try to run the following piece of code, I get this error:
QuoteWarning: mysql_query(): sup

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
Concatenate two strings ??? 
I have string one  $string1 and another  $string2.

How to concatenate (add) both of them $str
foreach result into a single variable 
Hi,

I have this code... 

Code: [Select]foreach ($_POST['Interests'] as $interest =&
Inserting the current date/time while submitting the forum 
What do I need to add below to update the current date/time? I have a field in the database called d
script and html conflict in trying to create a header. 
I have an error is occurring because of an html webpage with a "php require" at the top of
PHP Programming error. Please help! 
Hi there,

Am making a website for a friend and have encountered a problem that i need fixing 
sql error 
I have been looking at this code for 20mins and can't work out what I am doing wrong. There is somet