pgx-samples icon indicating copy to clipboard operation
pgx-samples copied to clipboard
verified publisher icon oracle-samples

load csv failed

Open vkjuju opened this issue 1 year ago • 3 comments

Thanks for sharing , have you hit the following error ? any advice would be appreciated.

SQL> load bank_accounts bankgraphdataset/bank_accounts.csv new; load bank_accounts bankgraphdataset/bank_accounts.csv new * ERROR at line 1: ORA-00900: invalid SQL statement Help: https://docs.oracle.com/error-help/db/ora-00900/

vkjuju avatar Apr 17 '24 05:04 vkjuju

sorry, I forgot to run oracle-graph-23c-sqldeveloper.sql, please ignore my previous issue

vkjuju avatar Apr 17 '24 06:04 vkjuju

sorr , after running that oracle-graph-23c-sqldeveloper.sql, I still hit the same error as shown below:

SQL> load bank_accounts bankgraphdataset/bank_accounts.csv new; load bank_accounts bankgraphdataset/bank_accounts.csv new * ERROR at line 1: ORA-00900: invalid SQL statement Help: https://docs.oracle.com/error-help/db/ora-00900/

vkjuju avatar Apr 17 '24 06:04 vkjuju

Hi, it looks like the load command is not recognized. Are you using SQLcl, if so what version?

https://docs.oracle.com/en/database/oracle/sql-developer-command-line/24.1/sqcug/loading-file.html#GUID-44F05C51-9AAF-47A1-94B4-C2AAB4F1EF6F

rahul-tasker avatar Apr 18 '24 14:04 rahul-tasker