Category: Oracle

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...

Oracle VARCHAR2(1) vs CHAR(1)? 0

Oracle VARCHAR2(1) vs CHAR(1)?

Well, minimum size for both Oracle datatypes is 1 byte. So in terms of storage, they’ll both consume either null or 1 byte in storage space. So, when declaring a character datatype with a...

“Typo” in Oracle ApEx Manage Services Page 0

“Typo” in Oracle ApEx Manage Services Page

Could a developer in Oracle please fix the “typo” in the Manage Services page in Oracle Application Express. I’ve been looking at the error for some time now and was hoping that it will...

Convert Oracle ApEx 3.1 Package Export to 3.0 0

Convert Oracle ApEx 3.1 Package Export to 3.0

Here’s a useful ASP page which I wrote which will convert an Oracle Application Express 3.1 package export (or page export) to 3.0 automatically! Just in case you developed an application in 3.1, but need...