Re: Help with ORACLE D2K REPORT BUILDER

From: Harsha Karan <Harsha.Karan_at_priority-health.com>
Date: Thu, 23 Jul 1998 09:24:20 -0400
Message-ID: <35B73984.2ACC_at_priority-health.com>


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

Original text of this message