Error code of a BRIDGE command in sqlcl
One can use WHENEVER SQLERROR
in sqlcl to specify an action if a SQL command generates an error. Does any similar posibility exist for a BRIDGE command?
BRIDGE table1 as "jdbc:oracle:thin:scott/tiger@localhost:1521:orcl"(select * from dept);
If there is any problem with connect information, then BRIDGE throws no ORA- or any similar error messages. Only an invalid syntax message followed by usage/help text are displayed.
BRIDGE Command has invalid syntax (or username or password incorrect) BRIDGE ---- Used mainly to script data move between two connections/schemas It also includes functionality to dynamically create Oracle tables which "fit" the data being received through JDBC ... ... (full usage text)