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

utf8_general_ci error ??
I have all kinds of data to be inserted in database table

//I am getting this error

Yo

Help with Contact Form
I have this Form on an html page and the associated code on page.php (below).
I keep getting the

Users and Groups with PHP Classes
Hi,

I have setup what I hope to be a good working User class. Now I want to introduce group m

login from external site
Hi my new experience begins, Now what i am trying to do is i make three pages, login.php logout.php

DateTimeZone::listIdentifiers headache
http://php.net/manual/en/datetimezone.listidentifiers.php


So the documentation states tha

SAP Business Suite
Hi all:

Within the SAP Business Suite solution I would like to ask you the main differenc

Using system() and bringing back the results
I am aware that you can use system() within PHP to execute system commands, but I was wondering if t

Drop Down and text box issue
Is it possible to set a drop down list and text boxes to a certain width?

here is my code

UPLOAD IMAGES NOT WORKING!
Hi there i have a upload script in which it uploads the picture to a folder than creates two thumbna

PHP template help
Ok, I don't know if anyone can help me but I am using PHP templates to make a site. I am a newbie an