Re: Forms6i BUG - Block based on PLSQL procedure

From: Marc Billiet <first.last_at_com.hydro.switch.this>
Date: Mon, 17 Dec 2001 15:19:44 GMT
Message-ID: <20011217.15194456_at_y1032696.hae.hydro.com>


Op 2001-12-14, 15:40:25, schreef "Dmitry Pangin" <pangin_at_mail.ru> over het thema Forms6i BUG - Block based on PLSQL procedure:

> Need Help!!!

> Found very ugly bag in Oracle Developer 6i on WinNT/Win2K/WinXP :

> 1) I've created database block based on a stored procedure wich returns
> pl/sql table.
> 2) When procedure returns an emty pl/sql table (for example - query
returns
> no rows) forms runtime falls out. Error occurs in built-in procedure
> plsql_table.populate_block.
> 3) All found patches and even upgrading to Rel.2 didn't solve this
> problem...
> 4) In Forms5.0 the same module works well...

Do you mean bug 1068368 (see metalink.oracle.com) : do you get FRM-40733 ? You can eventually trap it by the ON-ERROR trigger, but there doesn't seem to be a patch yet.

Marc Received on Mon Dec 17 2001 - 16:19:44 CET

Original text of this message