Compiling PL/SQL and using TOAD to write stored procedures :
PL/SQL compiler (version?) is quite stupid: ” Missing a semi-colon flags a line several lines below where the actual semi-colon is missing.” Likewise for a missing single quote character
To escape the single quote character, double it.” Therefore four consecutive single quotes is a string consisting of a single quote
When the compiler reports a compiler error at a certain line, that line # is relative to the start of the Body of stored procedure (assuming you are editing the Body and not the Spec)
To compile and “save” your stored procedure to the Oracle server in TOAD, be sure to use the “Execute As Script” button (
) in the Editor. Do NOT use the “Execute/compile statement at caret” button.
link
: http://buildingaircastles.blogspot.com/2010/11/compiling-plsql-and-using-toad-to-write.html
Comments
comments
Tags: coding, Compiling PL/SQL, Compiling PL/SQL and using TOAD to write stored procedures, Oracle, scripts, stored procedures, to write stored procedures, Toad, using TOAD
This entry was posted
on Wednesday, June 12th, 2013 at 10:00 am and is filed under Oracle.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
