Can't find output from HTP.P
618236Sep 8 2009 — edited Sep 8 2009Hi,
My stored procedure outputs XML via HTP.P; I know it works on another server that has OWA (mod_plsql) installed, but I'm trying to run it from SQL Developer. I'm unable to find the output either when I select its package and select "Execute", or when calling it from the SQL Worksheet like this:
DECLARE
PCODE VARCHAR2(200);
BEGIN
PCODE := NULL;
POC_CBU.P_SEARCH_PRODUCTS(
PCODE => 124
);
END;
The "Messages - Log" just tells me of the connect to and disconnect from the database, and the OWA Pane is empty, and there is no error message... Am I not looking in the right places for the XML output, or am I doing this totally wrong?
Best regards,
Chris.