Re: Dynamic PL/SQL and boolean

Shaavik wrote in message <8vk9mj$17g$1_at_wanadoo.fr>...
>Hi,
>
>I try to use dynamic SQL but I have a problem with boolean variable.
>
>Can anyone explain me how to do this :
>
 

>dbms_sql.parse( li_cursor, 'SELECT ps_si(1''>''2, ''toto'', ''tata'') from
>dual', dbms_sql.V7);

If you really called ps_si in this way it is obvious why it did not work. 1">2" should be 1>2. But even this will not work, because you cannot use expressions that return booleans in SQL.

Try to execute this in SQL+:

SELECT (1>2) FROM DUAL; Then you will also get the "missing right parenthesis message".

Se vi vere alvokis ps_si tiel klare kial tio ne funkcias. 1">2" devus esti 1>2. Sed ech tio chi ne funkcios, char oni ne povas uzi esprimojn kiuj redonas buleajn variablojn en SQL.

Provu ekzekuti tion en SQL+:

SELECT (1>2) FROM DUAL; Tiam vi ankau ricevos la "mankanta dekstra parentezo mesagho".

Gerard van Wilgen Received on Mon Nov 27 2000 - 11:02:41 CST