Archive for 2013
June 12th, 2013, posted in Oracle
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
June 12th, 2013, posted in COMiCS
June 11th, 2013, posted in Arrow, Art, BoYs
” If the enemy is in range, so are you. “
June 11th, 2013, posted in ANiMALS
June 10th, 2013, posted in Hannibal
