Re: Place SQL statements in PL/SQL procedure but failed...

From: IDEDWARDS <idedwards_at_aol.com>
Date: 06 Jan 2000 21:28:30 GMT
Message-ID: <20000106162830.01136.00000094@ng-fj1.aol.com>

You can't perform DDL in PL/SQL blocks. One solution however is to use the dbms_sql package to execute dynamic sql. If you take a look at the dbmssql.sql script found in the rdbms/admin directory on your database server this will give you some examples of using the package.

Ed Received on Thu Jan 06 2000 - 15:28:30 CST

This message: [ Message body ]
Next message: Dan Metzger: "visual basic returns 0's instead of actual numeric values"
Previous message: Sybrand Bakker: "Re: performance with many columns"
In reply to: laulau823_at_my-deja.com: "Place SQL statements in PL/SQL procedure but failed..."
Next in thread: Vishal Makhija: "Re: Place SQL statements in PL/SQL procedure but failed..."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US