Blog Archives

Execute immediate results in ora-00911 invalid character

Note to self: when receiving this error while executing DML using execute immediate, check for a semicolon (;) at the end of your statement. REMOVE! Share PostTwitterFacebookGoogle +1Email

Posted in Oracle, PEBKAC, Pl/Sql Tagged with: , ,

Compound triggers

This entry is part 8 of 8 in the series New Pl/Sql features 11g

This entry is part 8 of 8 in the series New Pl/Sql features 11gIf you put business rules into triggers validating your data your could easily grow a considerable forest around your tables. Making it hard to see for anyone

Posted in Oracle, Pl/Sql Tagged with: , , ,

PL/SQL Function Result Cache

This entry is part 6 of 8 in the series New Pl/Sql features 11g

This entry is part 6 of 8 in the series New Pl/Sql features 11gWith release 1 of 11g Oracle introduced PL/SQL Function Result Cache. As of release 2 of 11g Oracle further improved PL/SQL Function Result Cache. I’m not saying

Posted in Oracle, Pl/Sql Tagged with: , ,

Use named and mixed notation from SQL

This entry is part 5 of 8 in the series New Pl/Sql features 11g

This entry is part 5 of 8 in the series New Pl/Sql features 11gFor Pl/SQL program invocations it has named & mixed has been around for quite some time.However it you attempted the same function call from SQL prior to

Posted in Oracle, Pl/Sql Tagged with: , ,

Dynamic SQL Enhancements

This entry is part 4 of 8 in the series New Pl/Sql features 11g

This entry is part 4 of 8 in the series New Pl/Sql features 11gChanges have been made to both Native Dynamic SQL (NDS) and the DBMS_SQL package: Changes to NDS: the 32k limit has been lifted; EXECUTE IMMEDIATE now allows

Posted in Oracle, Pl/Sql Tagged with: , ,

CONTINUE Statement

This entry is part 2 of 8 in the series New Pl/Sql features 11g

This entry is part 2 of 8 in the series New Pl/Sql features 11gThe CONTINUE statement exits the current iteration of a loop and transfers control to the next iteration (in contrast with the EXIT statement, which exits a loop

Posted in Oracle, Pl/Sql Tagged with: , ,

SIMPLE Data Types

This entry is part 1 of 8 in the series New Pl/Sql features 11g

This entry is part 1 of 8 in the series New Pl/Sql features 11gOracle introduced new datatype in release 1 of 11g. The simple stuf! SIMPLE_INTEGER; subtype of PLS_INTEGER SIMPLE_FLOAT; subtype of BINARY_FLOAT SIMPLE_DOUBLE; subtype of BINARY_DOUBLE These simple datatypes

Posted in Pl/Sql Tagged with: , ,

Dynamic Wrap

This entry is part 8 of 13 in the series New Pl/Sql features 10g

This entry is part 8 of 13 in the series New Pl/Sql features 10gThe 2nd release of Oracle 10g added 2 new modules to the DMBS_DLL package. WRAP; function returning an obfuscated version of your code CREATE_WRAPPED; procedure compiling an

Posted in Pl/Sql Tagged with: , ,

Automatic PL/SQL optimization

This entry is part 7 of 13 in the series New Pl/Sql features 10g

This entry is part 7 of 13 in the series New Pl/Sql features 10gAs of 10g Oracle introduced automatic PL/SQL optimization. Which has 3 settings: PLSQL_OPTIMIZE_LEVEL=0 Optimization is disabled which might be in order if you find the optimization alters

Posted in Pl/Sql Tagged with: , ,

Enhancements to PL/SQL Native Compilation

This entry is part 6 of 13 in the series New Pl/Sql features 10g

This entry is part 6 of 13 in the series New Pl/Sql features 10gThis topic is rather scarcely explained. Simply because it’s part of a much larger topic of native compilation. So the only information here is what has been

Posted in Pl/Sql Tagged with: , ,