SQL & PL/SQL

We have purchased a product called Access Manager for DB2 and installed it on our AS400. This gives us the connectivitiy to Oracle server with which we do the Warehouse management software interface using our legacy system on AS400.

I have written several programs in SQLRPGLE and not quite sure as to how I can handle errors coming out of Oracle server.

As per my knowledge in my programs, I do

declare cursor
open cursor
fetch
dow look for sqlstate
fetch next row
enddo
close cursor

I am also new to this much of SQL.

Now, my programs are running in production and works just fine if we don;t have any issues with oracle server (database server down etc.).

My question is if the database server goes down for any reason, my SQLRPGLE progam starts giving me cursor not open errors, the actual error is as follows:

Connection to relational database HJAWCD1 already exists.

ARDUPAR: ARDUPAR: rc=-1(OCI_ERROR) from OCIStmtExecute when asking for
Describe-Info
ARDUPAR(1): ORA-03114: not connected to ORACLE
ARDAROC: rc = -1 from parse
SQLSTATE class unknown - SQLSTATE 72000, SQLCODE -969.
Cursor SEHOST not open.
Cursor SEHOST not open.
Cursor SEHOST not open.

So although, the connection exist between the AS400 and Oracle server as suggested from first statement, but then the cursor is giving me problems of not opening.

what I would like to know is how do I check in my SQL statement the error and somehow reconnect and open the cursor again.

Please help in this regard, since I am not finding any help from iseries world becuase no one seems to have knowledge about this product that we have installed and I don;t have too mcuh of documentation on the product nor do I have any sample handling messages program using RPGLE between oracle and AS400 using the product.

Regards
Farhan Qadri