Re: Value error

Nick -

• try the interactive form of the select statement under SQL*PLUS, eg select field1 from table1 where ...... . If it works, still using SQL*PLUS,embed it in a simple anoymous PL/SQL block, retrieving back to a variable, eg

set serveroutput on
declare

    var1 varchar2(15); --or whatever begin

    select field1 into var1 from table1 where ....;     dbms_output.put_line(var1);
 end:

this should give some clues.
rgds, john

Nick Lehane wrote in message
<01bde605$4f590160$eb58ea9e_at_ukp016543.logica.co.uk>...
>Hi all,
>
>Just a quick question - I've got an SQL Select statement which I know is
>correct because it retrieves what I want in SQL server, but using it in
>forms 4.5 is a different matter.
>
>The only difference between the statements is that I am basing the
>statement on a global variable as opposed to hard coding the string to
>search on (as is done directly in the server).
>
>I have tried all sorts to get round this but with no luck. Can anyone
>offer some help please? I might just be doing something simple wrong.
>
>Thanks,
>
>Nick
Received on Tue Sep 22 1998 - 10:09:02 CDT