Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report works locally failing on server (PLS-00382: expression is of wrong type)

Status
Not open for further replies.

holyus

Programmer
Aug 21, 2012
2
US
I have a simple report running against an Oracle Function (it also works with an SP with same logic) that works fine in eRD or locally on my machine (the rox) however the same does not work on out Actuate server with the error below. Both are using the same ActuateDD 5.3 driver and same credentials, db etc.

Status No: 1 :
Basic Error: 1011
Module: afc\db.bas
Line: 189

Database Error
2: Error generated by the connected data source ...
6550: [SQL State] S1000: [ActuateDD][ODBC Oracle Wire Protocol driver][Oracle]ORA-06550: line 1, column 17:
PLS-00382: expression is of wrong type
ORA-06550: line 1, column 9:
PL/SQL: Statement ignored


the function is:

create or replace
FUNCTION ACT_DUMMY_FUNC
(
CIN IN STRING
)
RETURN SYS_REFCURSOR
AS
my_cursor SYS_REFCURSOR;
BEGIN
-- ignoring the CIN parameter for now

open my_cursor for select * from OWNER.ACT_DUMMY_DATA;
return my_cursor;
END ACT_DUMMY_FUNC;
 
Never mind, resolved it. odbc.ini on the server needed the ProcedureRetResults set to 1.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top