Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Executing Procedure from shell script..
Top Forums Shell Programming and Scripting Executing Procedure from shell script.. Post 302504917 by msrahman on Tuesday 15th of March 2011 06:47:38 PM
Old 03-15-2011
I tried with '/' at the end of the script, and i am got this error;
HTML Code:
Enter password:
set serveroutput on size 1000000
    *
ERROR at line 2:
ORA-06550: line 2, column 5:
PL/SQL: ORA-00922: missing or invalid option
ORA-06550: line 2, column 1:
PL/SQL: SQL Statement ignored
Also in the script, line
HTML Code:
BEGIN
set serveroutput on size 1000000
execute zx01211.PDAC_UPDATE_ALLOW_DENY_SERV;
END;
/
i have used "Schema name.procedure name".
HTML Code:
BEGIN
set serveroutput on size 1000000
execute zx01211.PDAC_UPDATE_ALLOW_DENY_SERV;
END;
/
Is it the right way to use in the .sql script to execute the procedure?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Oracle procedure is not executing in uix

Hi Guys, I am trying to tun a oracle proedure throgh unix shell script but it is not running i dont know why ? i have tested this procedure in sqlplus and it was working fine. can you see the script and sql file and let me know where is my mistake. script:bm_chart_table_loading.sh ... (3 Replies)
Discussion started by: shary
3 Replies

2. Shell Programming and Scripting

Shell Script for call a procedure in Oracle DB

Hi everyone! I'm new with Shell Scripting, and I have to do a shell script to call a procedure, which have 2 input parameters, the directory(from server) and the txt file (which have informations to update/insert in DB). I have to create a shell script to execute that procedure for each txt... (5 Replies)
Discussion started by: renatoal
5 Replies

3. Shell Programming and Scripting

How to execute the stored procedure from shell script

How to execute the stored procedure from shell script and is there any possibility to print the dbms output in a log file. (2 Replies)
Discussion started by: dineshmurs
2 Replies

4. Shell Programming and Scripting

Executing oracle procedure using cronjob

Hi, Below is the code to execute the procedure "dbms_job.broken" from the shell script. on executing manually, it works properly without any error. but it is not working when scheduled using the cronjob. #!/usr/bin/bash user_name="oracdb" password="ora123" tns="localdb"... (2 Replies)
Discussion started by: milink
2 Replies

5. Shell Programming and Scripting

How to get OUT parameter of a stored procedure in shell script?

I am invoking a SQL script from shell script. This SQL script will invoke a stored procedure(which has the OUT parameter). I want to have the OUT parameter in the shell script as a variable. Is this possible? (6 Replies)
Discussion started by: vel4ever
6 Replies

6. Shell Programming and Scripting

Executing procedure using script

Hi, I want to have a automted script to exceute 20 procedures one by one. Suppose below is one procedure once it get executed script will write "PL/SQL procedure successfully completed." to a log for ex- exec dbms_stats.gather_table_stats(); Now later procedure starts executing... (1 Reply)
Discussion started by: sv0081493
1 Replies

7. Shell Programming and Scripting

SP2-0642 error while executing procedure from shell script

hi all, i have a unix script where i am calling a database procedure from it. while executing the procedure i am getting an error: but when i tried to call the same procedure manually then it ran successfully, i goggled this issue and found timezone.dat file missing at... (0 Replies)
Discussion started by: lovelysethii
0 Replies

8. Shell Programming and Scripting

Stored Procedure not executing

below code is not executing the stored procedure,not sure what the issue.Even sqllog is blank.please help me its very urgent. sqlplus -s $connect_str@$DB_ORACLE_SID >> ${SQL_LOG_FILE} << EOF set serverout on set feed off set head off set pages 0 set colsep , set tab off set lin 150... (3 Replies)
Discussion started by: katakamvivek
3 Replies

9. Shell Programming and Scripting

Why i can't execute the procedure in shell script?

i have the following code inside a shell script .prog in oracle server when i call the program DBMS_OUTPUT.PUT_LINE(x_return_status|| ln_rep_req_id); will return 0 , it is very strange , i try to submit the concurrent request in oracle , and it can successfully executed, what am i missing ? i... (1 Reply)
Discussion started by: feilhk
1 Replies

10. Shell Programming and Scripting

Error while running Procedure in shell script

Hi All, I am running the below proc in unix by connecting through sqlplus and the procedure is completing successfully. But when i am trying to run through shell scripting by using function. I am getting the error as follows. Please guide me where I am going wrong. #!/bin/sh opera () {... (6 Replies)
Discussion started by: bhas85
6 Replies

LEARN ABOUT DEBIAN

sql::translator::producer::html

SQL::Translator::Producer::HTML(3pm)			User Contributed Perl Documentation		      SQL::Translator::Producer::HTML(3pm)

NAME

       SQL::Translator::Producer::HTML - HTML producer for SQL::Translator

SYNOPSIS

	 use SQL::Translator::Producer::HTML;

DESCRIPTION

       Creates an HTML document describing the tables.

       The HTML produced is composed of a number of tables:

       Links
	   A link table sits at the top of the output, and contains anchored links to elements in the rest of the document.

	   If the nolinktable producer arg is present, then this table is not produced.

       Tables
	   Each table in the schema has its own HTML table.  The top row is a row of <th> elements, with a class of FieldHeader; these elements
	   are Field Name, Data Type, Size, Default Value, Other and Foreign Key.  Each successive row describes one field in the table, and has a
	   class of FieldCell$item, where $item id corresponds to the label of the column.  For example:

	       <tr>
		   <td class="FieldCellName"><a name="random-id">id</a></td>
		   <td class="FieldCellType">int</td>
		   <td class="FieldCellSize">11</td>
		   <td class="FieldCellDefault"></td>
		   <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td>
		   <td class="FieldCellFK"></td>
	       </tr>

	       <tr>
		   <td class="FieldCellName"><a name="random-foo">foo</a></td>
		   <td class="FieldCellType">varchar</td>
		   <td class="FieldCellSize">255</td>
		   <td class="FieldCellDefault"></td>
		   <td class="FieldCellOther">NOT NULL</td>
		   <td class="FieldCellFK"></td>
	       </tr>

	       <tr>
		   <td class="FieldCellName"><a name="random-updated">updated</a></td>
		   <td class="FieldCellType">timestamp</td>
		   <td class="FieldCellSize">0</td>
		   <td class="FieldCellDefault"></td>
		   <td class="FieldCellOther"></td>
		   <td class="FieldCellFK"></td>
	       </tr>

       Unless the nowrap producer arg is present, the HTML will be enclosed in a basic HTML header and footer.

       If the pretty producer arg is present, the generated HTML will be nicely spaced and human-readable.  Otherwise, it will have very little
       insignificant whitespace and be generally smaller.

AUTHORS

       Ken Youens-Clark <kclark@cpan.org>, Darren Chamberlain <darren@cpan.org>.

perl v5.14.2							    2012-01-18				      SQL::Translator::Producer::HTML(3pm)
All times are GMT -4. The time now is 05:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy