The quote_dotted() function will return the identifier (table name or column name) appropriately quoted for the remote data source. This function will obtain the appropriate quote characters from the remote data source. This function can be used in conjuction with rexecute function.
A string will be returned containing the quoted identifier.
SQLState | Error Code | Error Text | Description |
---|---|---|---|
22023 | VD011 | Supplied DSN [name] is not valid |
This simple example shows an identifier from a remote Oracle data source being correctly quoted using the quote_dotted() function from ISQL.
SQL> select quote_dotted ('oracle', 'DEMO.EMP'); callret VARCHAR _______________________________________________________________________________ "DEMO"."EMP" 1 Rows. -- 2 msec.