Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EXEC_SQL Package With Ora-306500 error

Abbas MehdiAug 16 2013 — edited Aug 21 2013

declare

    v_db varchar2(255);

    v_conn EXEC_SQL.ConnType;

    v_cur EXEC_SQL.CursType;

    al_btn number;

begin

    --v_db := 'a/a@ODBC:health'; --'test/test@ODBC:UG2000';

    v_db := 'test/test@ODBC:UG2000';

    v_conn := EXEC_SQL.OPEN_CONNECTION(v_db);

    if EXEC_SQL.IS_CONNECTED(v_conn) then

    al_btn := show_alert('success');

    else al_btn := show_alert('failure');

    end if;

End;

Hi all ,

I am getting this error when i try to execute the above statments.

Ora-306500

This post has been answered by Abbas Mehdi on Aug 21 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 18 2013
Added on Aug 16 2013
3 comments
660 views