12-11-2003
yeah ,
the oracle error is resolved.........
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
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
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
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
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
Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies
9. Shell Programming and Scripting
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
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 DEBIAN
sql::translator::parser
SQL::Translator::Parser(3pm) User Contributed Perl Documentation SQL::Translator::Parser(3pm)
NAME
SQL::Translator::Parser - describes how to write a parser
DESCRIPTION
Parser modules that get invoked by SQL::Translator need to implement a single function: parse. This function will be called by the
SQL::Translator instance as $class::parse($tr, $data_as_string), where $tr is a SQL::Translator instance. Other than that, the classes are
free to define any helper functions, or use any design pattern internally that make the most sense.
When the parser has determined what exists, it will communicate the structure to the producer through the SQL::Translator::Schema object.
This object can be retrieved from the translator (the first argument pass to parse) by calling the schema method:
my $schema = $tr->schema;
The Schema object has methods for adding tables, fields, indices, etc. For more information, consult the docs for SQL::Translator::Schema
and its related modules. For examples of how this works, examine the source code for existing SQL::Translator::Parser::* modules.
AUTHORS
Ken Youens-Clark, <kclark@cpan.org<gt>, darren chamberlain <darren@cpan.org>.
SEE ALSO
perl(1), SQL::Translator, SQL::Translator::Schema.
perl v5.14.2 2012-01-18 SQL::Translator::Parser(3pm)