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

Weird MySQL error, why am I recieving this?
PHP Code:


<?php require "global_settings.php"; ?>
<titl

need help with this contact form
I made this form and I need it to read the data and write the data to a table and its not working ca

insert PHP code into function
Hi,
I'm having problems when trying following:

I have:
Code: [Select]createBar("Do

PHP webpage & array print issue
I have this code running, and it works perfectly … however, see my bottom bit about what I see

Error Messaging not working
I changed the way my form tells the user of an error. But I can't seem to get it to work properly.

Multiple upload and Resize
I would like some help on my script I have the for my index.php

////

<html&

What are the two different files you download to update kernel?
What are the two different files you download to update kernel?

Echo Tweaking help!
HI. I would like to have the output of the entered variables repeat forever, but it's stopping at th

Website Direction...
I recently used this code to try and make it so the page loads as http://www.domain.com/ when you ty

Displaying Multidimensional Arrays...about to put my head in a vice, PLEASE HELP
I am fairly new to PHP and MySQL and I have a problem which I have been trying to resolve for days.