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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center