Re: Help with ORACLE D2K REPORT BUILDER

yonglove_at_usa.net wrote:
>
> Hello.
>
> Why is the system complaining about this SQL Query statement?
>
> select * from pmfdb.prov_mstr_file_at_gtw where prov# = :p_the_prov_number ;
>
> I have already defined the bind variable in the "user parameter" node. When I
> try to input the above SQL statement, I get this error:
>
> ORA-09100: Target system returned following message: Column NULL not found.
> (DBERR 2211)
> ORA-02063: preceding 2 lines from GTW ==> select * from
> pmfdb.prov_mstr_file_at_gtw where prov# = :p_the_prov_number ;
>
> What in the world is going on???
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

Try this

select * from pmfdb.prov_mstr_file_at_gtw where prov# = :parameter.p_the_prov_number ;

It should work Received on Thu Jul 23 1998 - 15:24:20 CEST