APEX Issue displaying dynamic PL/SQL content

Hi,  

   I have a weird issue with APEX that I cannot put my finger on. Basically I'm generating a custom HTML with a PL/SQL procedure that needs only one variable input.  

   The page has a PL/SQL Region with the following code:  

show_rda (:P108_SERVER_ID);  

show_rda is a stored procedure defined as follows:  

CREATE OR REPLACE PROCEDURE show_rda (server_id IN NUMBER) IS

BEGIN htp.p ('Server ID: ' ||server_id);

--Code to print out the RDA

END;   However in the page I only see

'Server ID: ' without actually getting the variable value.  

Now, I've tried both :P108_SERVER_ID and v('P108_SERVER_ID'), I even tried the old approach: GET_SESSION_STATE('P108_SERVER_ID') from within the PL/SQL block, but nothing seems to work. I know I'm missing something trivial here, but I'm out of ideas. I even tried changin the page's code to:  

BEGIN htp.p ('Server ID: ' ||server_id);

--Code to print out the RDA

END;   Instead of calling the stored procedure, but produced the same result.  

Any Ideas?  

Thanks in advanced.    

Guillermo Alan Bort

DBA / DBA Main Team  

EDS, an HP company

--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 16 2008 - 12:40:41 CDT