Re: APEX Issue displaying dynamic PL/SQL content

From: Toon Koppelaars <toon_at_rulegen.com>
Date: Thu, 16 Oct 2008 19:49:32 +0200
Message-ID: <bba9fbc50810161049i24d7e816u94354e823e932ad4@mail.gmail.com>


Guillermo,

The only logical conclusion can be that item P108_SERVER_ID, has not (yet) been assigned the value you expect it to have, when Apex renders your PL/SQL region (which calls your show_rda procedure). Causes for this can be various. What type of item is it? How is it's value assigned? How do you 'branch' to your region? Is page processing happening, which would assign the item (under normal circumstances)....

This really is an Apex question, and you would probably be better of posting this on the Apex forum on OTN.

Toon

On Thu, Oct 16, 2008 at 7:40 PM, Bort, Guillermo <guillermo.bort_at_eds.com>wrote:

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

-- 
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Toon Koppelaars
RuleGen BV
+31-615907269
toon_at_rulegen_dot_com
www_dot_rulegen_dot_com

Author: "Applied Mathematics for Database Professionals"

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

Original text of this message