Toad for oracle error codes3/22/2023 ![]() ![]() WHEN 2 THEN DBMS_SQL.COLUMN_VALUE(c,j,v_n_val) WHEN 1 THEN DBMS_SQL.COLUMN_VALUE(c,j,v_v_val) WHEN 12 THEN DBMS_SQL.DEFINE_COLUMN(c,j,v_d_val) ĭBMS_SQL.DEFINE_COLUMN(c,j,v_v_val,2000) WHEN 2 THEN DBMS_SQL.DEFINE_COLUMN(c,j,v_n_val) WHEN 1 THEN DBMS_SQL.DEFINE_COLUMN(c,j,v_v_val,2000) V_samefile BOOLEAN := (NVL(p_data_file,p_header_file) = p_header_file) ĭBMS_SQL.PARSE(c, p_sql, DBMS_SQL.NATIVE) ĭBMS_SQL.DESCRIBE_COLUMNS(c, col_cnt, rec_tab) GRANT READ, WRITE ON DIRECTORY TEST_DIR TO myuserĬREATE OR REPLACE PROCEDURE run_query(p_sql IN VARCHAR2 Here's one of my standard responses that uses DBMS_SQL to dynamically accept any query and output the results using UTL_FILE to a file on the database server (Note: UTL_FILE can only read/write files on the database server).ĬREATE OR REPLACE DIRECTORY TEST_DIR AS '\tmp\myfiles' i have suffice space on PC to accomodate the data.It's not necessarily about having space on your PC, it's about the memory allocation where TOAD is concerned. Pls tell me how to write pl/sql code to create file on client machine.Boht Toad and sql plus i got error. 1.7K Training / Learning / Certification.165.3K Java EE (Java Enterprise Edition).7.9K Oracle Database Express Edition (XE).3.8K Java and JavaScript in the Database. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |