SQL Developer (MOSC)

MOSC Banner

Error code of a BRIDGE command in sqlcl

in SQL Developer (MOSC) 2 commentsAnswered ✓

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center