Setting OAS PL/SQL ToolKit Function Values

[Quoted] I'm getting errors when I use the owa_util.get_cgi.env function. Following are the three values that I'm receiving the errors on:

v_sid := owa_util.get_cgi_env ('REMOTE_USER')
v_port := owa_util.get_cgi_env ('SERVER_PORT')
v_server := owa_util.get_cgi_env ('SERVER_NAME')

It seems like the pl/sql toolkit functions' values haven't been set. I re-installed the pl/sql toolkit but it made no difference. I created the following procedure to test "get_cgi_env":

SQL> create or replace procedure test_500481 is   2 begin
  3 owa_util.print_cgi_env;
  4 end;
  5 /

Procedure created.

SQL> exec test_500481
begin test_500481; end;

*
ERROR at line 1:

ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "OAS_PUBLIC.OWA_UTIL", line 329
ORA-06512: at "SUPER.TEST_500481", line 3
ORA-06512: at line 1

SQL> exec owa_util.showpage

PL/SQL procedure successfully completed.

Can anyone tell me how to set the pl/sql toolkit functions' values or suggest a solution? Thank you!

Alethea

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 11 2000 - 16:07:04 CET