Home » RDBMS Server » Server Administration » OWS and passing parameters to the pl/sql proc.
OWS and passing parameters to the pl/sql proc. [message #370516] Tue, 14 December 1999 01:31 Go to next message
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 Go to previous message
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
Previous Topic: OCI & result sets
Next Topic: Execute os file in Pl/SQL
Goto Forum:
  


Current Time: Wed Oct 28 07:20:21 CDT 2020