Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_SQL Table/Column Comment Problem
DBMS_SQL Table/Column Comment Problem [message #35726] Wed, 10 October 2001 11:49 Go to next message
Dirk Nielsen
Messages: 1
Registered: October 2001
Junior Member
Is it possible to "execute" or PARSE more than one SQL command in a dynamic SQL (DBMS_SQL) in *one* DBMS_SQL.PARSE statement? Basically, I want to define column and table comments by placing the COMMENT command "in-line" directly following the CREATE TABLE command, as opposed to breaking out each COMMENT command into separate PARSEs. This works perfectly in a basic SQL script execution, but doesn't seem to work when 'transposed' into a PL/SQL block using dynamic SQL. I've tried modifying the SQL [[Comment]] statement with varying syntax to no avail (generally I get some sort of invalid identifier error depending on how the SQL statement was formatted.) The script runs perfectly without the COMMENTs. Any help or suggestions would be appreciated.

----------------------------------------------------------------------
Re: DBMS_SQL Table/Column Comment Problem [message #35738 is a reply to message #35726] Thu, 11 October 2001 01:46 Go to previous message
Phenoracle
Messages: 35
Registered: March 2001
Member
Hi,

I have posted some tips on performance tuning
Dynamic SQL.
This also should help you with this issue.

http://www.phenoracle.co.uk

Have Fun

Rae



----------------------------------------------------------------------
Previous Topic: ftp text file by using PL/SQL?
Next Topic: To find one row before & after all retrieved rows
Goto Forum:
  


Current Time: Sat May 25 02:37:17 CDT 2024