Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Value error
Nick -
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