When the below package is run it returns:
ERROR line 10, col 29, ending_line 10, ending_col 33, Found 'using', Expecting: ; -or- AS IS -or- AUTHID CLUSTER DETERMINISTIC ORDER PARALLEL_ENABLE PIPELINED RESULT_CACHE
For example:
CREATE OR REPLACE PACKAGE UTIL$CSV AS
FUNCTION load_from_file(
p_dir in varchar2,
p_filename in varchar2,
p_delimiter in varchar2 default ',',
p_enclosed in varchar2 default '',
p_sample in number default 1,
p_cols_firstline in number default 1
)
return anydataset pipelined using bsutil_csv_parser;
END UTIL$CSV;
This was tested in SQLPlus and it compiled with no errors but returns the error stated above when run in Toad 9.7.2.
WORKAROUND:
None
STATUS:
Waiting for fix in a future release Toad for Oracle.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center