DBMS_SQL question

From: Jared Hecker <jared_at_hwai.com>
Date: 1996/05/18
Message-ID: <319d4181.77334_at_news.planet.net>#1/1

Hi, all -

Quick question (I couldn't tell from the ADG) - can I mix DBMS_SQL-type commands with regular commands in a stored procedure? I need to generate a select statement in an sp dynamically, necessitating DBMS_SQL package. I have a few other commands to wrap around the results of that SQL. Does it all need to run through the DBMS_SQL package, or can I mix and match?

If it is convenient, e-mail will reach me faster.

TIA - Regads,
jh

Jared Hecker              | Oracle  and Sybase Architect and DBA
jared_at_planet.net          | - consulting in the 

76276.740_at_compuserve.com | NYC/NJ region Received on Sat May 18 1996 - 00:00:00 CEST