All Questions
5 questions
0
votes
1
answer
776
views
How to call a procedure inside a package body using SQLPLUS in Oracle 11g
I am using Oracle 11g. The procedure below converts a txt file to an xls file. I want to call this procedure via SQLPLUS. The name of the package body is "VMDB_OAS_doc_utils"
and the procedure name ...
- 143
3
votes
3
answers
5k
views
SQL Plus - how to pass big string to procedure CLOB's parameter
I have procedure that receives an XML:
CREATE OR REPLACE PROCEDURE PROCESS_XML(xml IN CLOB) AS
BEGIN
DBMS_OUTPUT.PUT_LINE('XML processing started');
END;
Now I'm doing a bash script that will ...
- 1,536
4
votes
1
answer
544
views
Oracle procedure works only when set serveroutput on;
Strange behavior trying to insert a record with a stored procedure.
Only works with set serveroutput on:
Thanks.
SQL*Plus: Release 11.2.0.1.0 Production on Tue May 31 22:48:25 2016
Copyright (c)...
- 43
1
vote
1
answer
759
views
stored procedure for select query not giving output
I am using sqlplus and have a table named users from which I wish to retrieve all values with the help of a stored procedure in oracle. Here is what I am trying to do -
create or replace procedure ...
- 93
4
votes
2
answers
8k
views
Oracle output in sqlplus
I have an oracle stored procedure which has output to the users in the form of
DBMS_OUTPUT.PUT_LINE('....');
I run the stored procedure through .sql file in sqlplus and none of the output messages of ...
- 255