DBMS_SQL Table/Column Comment Problem [message #35726] |
Wed, 10 October 2001 11:49 |
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.
----------------------------------------------------------------------
|
|
|
|