crash4ever
Programmer
Hi,
I've used SQL Designer to build a SQL statement that used PL/SQL package. The package/function will return a concatenation of several number values with pipe delimiter.
I have set the return variable data type into a CHAR(150).
When I use this SQL statement as my source in Crystal report, it always treat it as a MEMO field not a CHAR/String field. That is why I'm having problem to use formulas on it.
Why did CR 8.5 do this even though I've set the returning variable as CHAR(150)? I've tried to used CAST option on the function calls within the select statement:
SELECT CAST(package.function(invar1, invar2) AS CHAR(150)) Claim_Count FROM TableA;
Somehow it did not like that statement. It always said about missing right paranthesis. So do we have other option here? All I want to do is manipulating the information on that field using formula.
Thanks,
Vicky
I've used SQL Designer to build a SQL statement that used PL/SQL package. The package/function will return a concatenation of several number values with pipe delimiter.
I have set the return variable data type into a CHAR(150).
When I use this SQL statement as my source in Crystal report, it always treat it as a MEMO field not a CHAR/String field. That is why I'm having problem to use formulas on it.
Why did CR 8.5 do this even though I've set the returning variable as CHAR(150)? I've tried to used CAST option on the function calls within the select statement:
SELECT CAST(package.function(invar1, invar2) AS CHAR(150)) Claim_Count FROM TableA;
Somehow it did not like that statement. It always said about missing right paranthesis. So do we have other option here? All I want to do is manipulating the information on that field using formula.
Thanks,
Vicky