[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
error using packaged procedure
- Subject: error using packaged procedure
- From: Bob Shiflett <shifletb@WLRFOODS.COM>
- Date: Fri, 8 Aug 1997 19:17:31 -0400
Does any one know why I am getting the following error when trying to
retrieve data from a packaged procedure?
Oracle OEXEC error -6502 in cursor 1: ORA-06502: PL/SQL: numeric or value
error
ORA-06512: at line 1
Error on line 17: DSQL: Could not execute sql.
SQR: Program Aborting.
sqr statement:
begin-sql
declare
company_name varchar2(50) := null;;
system_name varchar2(50) := null;;
begin
wms.get_system_parameters(company_name,system_name);;
$company :=company_name;;
$system :=system_name;;
end;;
end-sql
when i exclude $company :=company_name;; $system :=system_name;;
there are no errors
the package procedure runs fine in sql and oracle forms 3.0.
system:
HP-UX 9000/829
Unix System V Release 4.0
Oracle7 Server Release 7.2.3.0.0
PL/SQL Release 2.2.3.0.0
SQL*Plus: Release 3.2.3.0.0
SQR V2.4.2
tia
Bob Shiflett : Software Engineer/Analyst
WLR Foods, inc.
Internet (Work) : shifletb@wlrfoods.com
Internet (Home) : shifletb@cfw.com
Voice : 540.896.0777
Fax : 540.896.1012