Category: PL/SQL

Getting Session Environment Parameters in Oracle 3

Getting Session Environment Parameters in Oracle

To display all environment variable values for a given oracle session, run the following code: begin FOR i IN 1..owa.num_cgi_vars LOOP htp.p(owa.cgi_var_name(i)||’ : ‘||owa.cgi_var_val(i)); END LOOP; end; The name of the environment variable and...

Loading a File Into a BLOB Object in Oracle 5

Loading a File Into a BLOB Object in Oracle

Loading a file into a BLOB object in Oracle is easy. All we need to do is use the DBMS_LOB package to load the file into a temporary LOB object. This is demonstrated in...

Improving Performance of Your Oracle Application Express Software 5

Improving Performance of Your Oracle Application Express Software

I am writing this article with the thread http://forums.oracle.com/forums/thread.jspa?messageID=3205216&#3205216 in mind. We have a very large workflow application written in Oracle Application Express, supporting some 3000+ users. This application was written with care, for...

HTTP Post from Oracle PL/SQL 5

HTTP Post from Oracle PL/SQL

I recently needed to execute a HTTP post from an ApEx application to another web page running as some sort of a service. For added security the web page service only accepted POST requests...