AndersonCJA
Programmer
Crystal Reports 8.0
Oracle 8I
Data expected = social security number based on the customer number from tablename where customer number = 01.
Function name: dbname.proc(pack_NBR.func_GETNUMBER)
Delima = I have been using a ssn number from database 1 report 1 to link to a subreport. The field I have been linking to in the subreport will no longer be available to me. I have been instructed to use a field from the function below.
The problem is I do not know how to use the function in my Crystal Report.
In the SQL Expression Editor, I have typed in the following:
(select pack_NBR.func_GETNUMBER(ssnfieldname, null, null) from tablename where tablefield = 01)
It runs fine in sql talk when it is typed like this:
select pack_NBR.func_GETNUMBER(ssnfieldname, null, null) from tablename where tablefield = 01;
However, when I add it to the SQL Expression Editor enclosed in parenthesis, I receive this error:
“Error in compiling SQL Expression :
Syntax error found here ”
Also, I should add that I am not able to add the function to my crystal report using database – add. I receive an error message:
“ODBC error: {MERANT][ODBC Oracle driver][Oracle]ORA-06550: line1, column 32:
PLS-00306: wrong number or types of arguments in call to ‘FUNC_GETNUMBER’
ORA-06550: LINE 1, column 8:
PL/SQL: Statement ignored “
Thank you any help, information or advice
Oracle 8I
Data expected = social security number based on the customer number from tablename where customer number = 01.
Function name: dbname.proc(pack_NBR.func_GETNUMBER)
Delima = I have been using a ssn number from database 1 report 1 to link to a subreport. The field I have been linking to in the subreport will no longer be available to me. I have been instructed to use a field from the function below.
The problem is I do not know how to use the function in my Crystal Report.
In the SQL Expression Editor, I have typed in the following:
(select pack_NBR.func_GETNUMBER(ssnfieldname, null, null) from tablename where tablefield = 01)
It runs fine in sql talk when it is typed like this:
select pack_NBR.func_GETNUMBER(ssnfieldname, null, null) from tablename where tablefield = 01;
However, when I add it to the SQL Expression Editor enclosed in parenthesis, I receive this error:
“Error in compiling SQL Expression :
Syntax error found here ”
Also, I should add that I am not able to add the function to my crystal report using database – add. I receive an error message:
“ODBC error: {MERANT][ODBC Oracle driver][Oracle]ORA-06550: line1, column 32:
PLS-00306: wrong number or types of arguments in call to ‘FUNC_GETNUMBER’
ORA-06550: LINE 1, column 8:
PL/SQL: Statement ignored “
Thank you any help, information or advice