Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Error while trying to fire a PL/SQL thro Unix Script
Top Forums Shell Programming and Scripting Error while trying to fire a PL/SQL thro Unix Script Post 44812 by dharmesht on Thursday 11th of December 2003 05:01:34 AM
Old 12-11-2003
yeah ,
the oracle error is resolved.........
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

script to connect to different ip address thro telnet or ssh

Hi, I have three ip address say x.x.x.x , y.y.y.y and z.z.z.z I am connecting to x.x.x.x first and from there i do telnet or ssh to y.y.y.y and getting into y and from there i do telnet or ssh to z.z.z.z i want to know, can we write a script, which can automatically connect from x to y... (3 Replies)
Discussion started by: vasikaran
3 Replies

2. Shell Programming and Scripting

Unix-Sql Loop error

Hi, I am getting the error "No matching <<", when i run the below. Is it that we can't execute SQL in a Unix loop. I am executing a SQL in a loop. Is it the EOF is written wrongly. . /opt/app/wlsconfigv61/domains/profiles/oracleV901.profile export DBUSER=ecdb01 set -A DBINSTANCE... (3 Replies)
Discussion started by: manu_byc
3 Replies

3. UNIX for Advanced & Expert Users

sql load error in unix

When i try to run a job in unix, i am getting sqlload error as, sqlload : file not found. Can any one please let me know whats the reason for this.. The PATH & ORACLE_HOME paths names are correct... thanks here is the script : plz hv a look TABLE_NAME= tablename... (1 Reply)
Discussion started by: abhi_123
1 Replies

4. Shell Programming and Scripting

(Urgent):Creating flat file using sql script and sqlplus from UNIX Shell Script

Hi, I need help urgently for following issue. Pls help me to resolve this issue. I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql) I given... (6 Replies)
Discussion started by: praka
6 Replies

5. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

Hi guys, I am new on here, I have a function in oracle that returns a specific value: create or replace PACKAGE BODY "CTC_ASDGET_SCHED" AS FUNCTION FN_ASDSCHEDULE_GET RETURN VARCHAR2 AS BEGIN DECLARE ASDSchedule varchar2(6); ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies

6. UNIX for Advanced & Expert Users

How to use parameter in sql script pass from unix script?

Hi, I am unable to use parameter in sql script passed from unix script. my sql script CREATE_SBI_LIST_GROUP.sql is like this - ------------------------------- SELECT SDS.ID "SO_ID", SDS.SO a1, sgp.sga__code SGA_CODE, FROM sga sga,sales_genl_provision sgp , comm_product_condn cpc... (2 Replies)
Discussion started by: apskaushik
2 Replies

7. Shell Programming and Scripting

Need to capture error of sybase sql in unix

Hi Gurus, I am very new in Unix, I have 1 script, in which I am truncating the table , then BCP the data in Sybase table, and then loading the data from sybase table to sybase table. every thing is working fine, but the problem is with Error. I made some hanges in my insert statement so... (1 Reply)
Discussion started by: aksar
1 Replies

8. Shell Programming and Scripting

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX?

Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies

9. Shell Programming and Scripting

How to pass Oracle sql script as argument to UNIX shell script?

Hi all, $ echo $SHELL /bin/bash Requirement - How to pass oracle sql script as argument to unix shell script? $ ./output.sh users.sql Below are the shell scripts and the oracle sql file in the same folder. Shell Script $ cat output.sh #!/bin/bash .... (7 Replies)
Discussion started by: a1_win
7 Replies

10. Shell Programming and Scripting

Call sql script from UNIX shell script

I know this question is out there in many forums, but I tried all the combinations in vain. I'm basically trying to call a sql script from a shell script. Below is my sql script (plsql.sql) DELCARE v_empno NUMBER := '&empno'; BEGIN select ename,sal from emp where empno = v_empno;... (3 Replies)
Discussion started by: FName_LName
3 Replies

LEARN ABOUT PHP

sql-types-with-pdo_4d-and-php

SQL-TYPES-WITH-PDO_4D-AND-PHP(3)					 1					  SQL-TYPES-WITH-PDO_4D-AND-PHP(3)

SQL types with PDO_4D and PHP - SQL types with PDO_4D and PHP

       Supported SQL types

       +-----------------+--------------------------------------+---+
       |  Type SQL 4D	 |					|   |
       |		 |					|   |
       |		 |	      Equivalent 4D		|   |
       |		 |					|   |
       |		 |		   Note 		|   |
       |		 |					|   |
       +-----------------+--------------------------------------+---+
       | ALPHA_NUMERIC	 |					|   |
       |		 |					|   |
       |		 |		   TEXT 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		T{ VARCHAR		|   |
       |		 |					|   |
       |		 |		   TEXT 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		 T{ TEXT		|   |
       |		 |					|   |
       |		 |		   TEXT 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |	       T{ TIMESTAMP		|   |
       |		 |					|   |
       |		 |		   DATE 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |	       T{ INTERVAL		|   |
       |		 |					|   |
       |		 |		   HOUR 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |	       T{ DURATION		|   |
       |		 |					|   |
       |		 |		   HOUR 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		T{ BOOLEAN		|   |
       |		 |					|   |
       |		 |		 BOOLEAN		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		  T{ BIT		|   |
       |		 |					|   |
       |		 |		 BOOLEAN		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		 T{ BYTE		|   |
       |		 |					|   |
       |		 |		  INT32 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		 T{ INT16		|   |
       |		 |					|   |
       |		 |		 SMALLINT		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |	       T{ SMALLINT		|   |
       |		 |					|   |
       |		 |		 SMALLINT		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		 T{ INT32		|   |
       |		 |					|   |
       |		 |		  INT32 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		  T{ INT		|   |
       |		 |					|   |
       |		 |		  INT32 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		 T{ INT64		|   |
       |		 |					|   |
       |		 |		  INT64 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		T{ NUMERIC		|   |
       |		 |					|   |
       |		 |		  INT64 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		 T{ REAL		|   |
       |		 |					|   |
       |		 |		   REAL 		|   |
       |		 |					|   |
       |		 | Unsupported (use VARCHAR conversion) |   |
       |		 |					|   |
       |     FLOAT	 |					|   |
       |		 |					|   |
       |		 |		  FLOAT 		|   |
       |		 |					|   |
       |		 | Unsupported (use VARCHAR conversion) |   |
       |		 |					|   |
       |DOUBLE PRECISION |					|   |
       |		 |					|   |
       |		 |		  FLOAT 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		 T{ BLOB		|   |
       |		 |					|   |
       |		 |		   BLOB 		|   |
       |		 |					|   |
       |		 | Must  use  a prepared statement, and |   |
       |		 | PDO::PARAM_LOB			|   |
       |		 |					|   |
       |  BIT VARYING	 |					|   |
       |		 |					|   |
       |		 |		   BLOB 		|   |
       |		 |					|   |
       |		 | Must use a prepared	statement,  and |   |
       |		 | PDO::PARAM_LOB			|   |
       |		 |					|   |
       |      CLOB	 |					|   |
       |		 |					|   |
       |		 |		   TEXT 		|   |
       |		 |					|   |
       |		 |					|   |
       |		 |		T{ PICTURE		|   |
       |		 |					|   |
       |		 |		 PICTURE		|   |
       |		 |					|   |
       |		 | Must  use  a prepared statement, and |   |
       |		 | PDO::PARAM_LOB			|   |
       |		 |					|   |
       +-----------------+--------------------------------------+---+
PHP Documentation Group 											  SQL-TYPES-WITH-PDO_4D-AND-PHP(3)
All times are GMT -4. The time now is 01:21 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy