OWS and passing parameters to the pl/sql proc. [message #370516] |
Tue, 14 December 1999 01:31 |
Semenov
Messages: 6 Registered: December 1999
|
Junior Member |
|
|
Hello !
Įäđāņōå âņåė !
How to pass this to the procedure? :
dinterface.login_validate?usernamep=&userpassp=&enter.x=27&enter.y=7
it's not work and tells me that @request failed@
It's not work because enter.x and enter.y did'nt passing correctly. What is i'm doing wrong?
define procedure
type entertype is record(
x integer:=0,
y integer:=0);
procedure login_validate
(usernamep in char default null,
userpassp in char default null,
enter in entertype);
Best regards, D.Semenov
Russia
Åņëč íåōđķäíî ōî įāėûëüōå ņđāįķ íā semionov@upsb.mplik.ru
|
|
|
Re: OWS and passing parameters to the pl/sql proc. [message #370518 is a reply to message #370516] |
Tue, 14 December 1999 11:56 |
hmg
Messages: 40 Registered: March 1999
|
Member |
|
|
Try this:
create or replace package dinterface
is
type mouse_image_coordinate is table of varchar2(20) index by binary_integer;
list mouse_image_coordinate;
procedure login_validate(usernamep in char default null,
userpassp in char default null,
enter in mouse_image_coordinate default list);
end;
/
show errors
create or replace package body dinterface
is
procedure login_validate(usernamep in char default null,
userpassp in char default null,
enter in mouse_image_coordinate default list)
is
begin
null;
end;
begin
list(1) := '-1';
list(2) := '-1';
end;
/
show errors
|
|
|