[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: (SQR 5528) ORACLE OEXEC error -1008 in cursor 4:
Thank you, David!
You pinpointed exactly where the problem was. After fixing it, it now works
like a charm.
Thanks again.
Tai.
On Tue, 10 Mar 1998, David Cholaghian wrote:
> Tai,
> The problem is with 'and sgbeops_term_code_eff in ($chk_term_1, $chk_term_2)'
> clause! Do the following:
>
> BEGIN-PROCEDURE xyz
> LET $term_code_in = '('||''''||$chk_term_1||''''||','||
> ''''||$chk_term_2||''''||')'
>
> BEGIN-SELECT
> ....
> ....
> ....
>
> where 0 < (select count (sgbeops_pidm)
> from sgbeops
> where sgbeops_pidm = w_eops.pidm
> and sgbeops_term_code_eff in [$term_code_in]
> )
> END-SELECT
> END-PROCEDURE xyz
>
>
>
> David Cholaghian
> Bentley College
> dcholaghian@bentley.edu
>