[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

error using packaged procedure



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