Dynamic SQL inside Stored Procedures

From: <ogalindo_at_my-dejanews.com>
Date: Thu, 20 Aug 1998 21:32:13 GMT
Message-ID: <6ri4kt$7sl$1@nnrp1.dejanews.com>

Hi everybody out there !

I have been trying to make a SELECT based in Dynamic SQL inside a ORACLE 7.3 (over NT) Stored Procedure.

I am a beginner, so I am sill confused with PL/SQL issues. ORACLE tech support told me I should use the DBMS_SQL package for Dynamic SQL, but all the information regarding dynamic SQL takes me to the procompilers tools documentation.

Is it possible to use the DBMS_SQL package into a PL/SQL pure environment ? Can I get a usefull guide of this package in the web ?

Thanks in advance, and hope somebody could guide me.

Octavio

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 20 1998 - 16:32:13 CDT