Hi,
I need to put this command in a batch shell.
sqlplus -s user/password @test.sql
and in the test.sql I have this command
select * from pbempl where pebempl_id = $1;
How I can pass the variable $1 from the batch shell???
Thanks (2 Replies)
Hi Folks,
This is a small chunk of the bigger problem which i am facing and some help here will help me resolve the rest of the issue.
Problem is that i need to pass the value of a variable from a shell script to a SQL query (infact a lot of SQL's)
i have the following solution but somehow... (4 Replies)
hi I all ,
I have sql statment in my shell script , I pass two argument to the script I need to pass the this two arguments to the sql statment
example :
runsql.sh "1" "2"
sql :
updat tables_x set y=0
where
A=:x should subsituted by "1"
and
B=:y shuold subsituted bt "2"... (1 Reply)
Hi guyz,
Posting a thread after a long time.
I want to pass two variables to unix shell script from sql script.
Note: I am calling sql script from unix script. sql script has 2 variables one is the return code for status of program run and second one email flag. I don't know how to capture... (3 Replies)
Hi Everyone,
Can anyone help me how do i call hash variable in to sql query in perl. Please see the script below
i have defined two Hash %lc and %tab as below
$lc{'REFF'}='V_RES_CLASS';
$lc{'CALE'}='V_CAP_CLASS';
$lc{'XRPD'}='V_XFMR_CLASS';
$tab{'V_RES_CLASS'}='V_MFR_SERS';... (6 Replies)
Hi all,
I am executing shell script in which I am using SQLLDR
In this SQLLDR I am passing text file having PL/SQL script. This script will produce some formated output, this output I have to spool in another text file. Currently I have given this in script file as following
Spool... (2 Replies)
Hi Guys,
I am trying to pass a string variable from Unix shell script to sqlplus as a parameter.
I have tried using single quotes with the variable name but it does not work. Please help me with it.
I am using BASH.
My code:
Your help is much appreciated.
Thanks,
shil (2 Replies)
Hello,
Here is the code i have written to get the count of a plsql query back to the unix.
function checkforCOIDs
{
countcheck=`sqlplus -s $1/$2@$3
whenever oserror exit sql.oscode rollback
whenever sqlerror exit sql.sqlcode rollback
set serverout on size 2000;
set head off feedback off... (2 Replies)
How to pass variable to sql file.
Im tryin in two ways,
Method 1:
my.sql
select * from table where col1 = '$1' and col2 = 'text';
Method 1execute: dbaccess database my.sql $var
Method2:
select * from table col1 in (`cat inputfile`) and col2 = 'text';
method... (2 Replies)
Hi Friend,
I have one file in which some number are mentioned and number of lines are vary every time
And i need to pass that number to my sql command from script.
Suppose i have file acc.txt
45456546456
45464564565
67854353454
67657612132
Number of records are vary every time.... (20 Replies)
Discussion started by: pallvi_mahajan
20 Replies
LEARN ABOUT PHP
mysqli_stmt
MYSQLI_STMT(3) 1 MYSQLI_STMT(3)The mysqli_stmt classINTRODUCTION
Represents a prepared statement.
CLASS SYNOPSIS
mysqli_stmt
mysqli_stmt
Properties
o
int$mysqli_stmt->affected_rows
o
int$mysqli_stmt->errno
o
array$mysqli_stmt->error_list
o
string$mysqli_stmt->error
o
int$mysqli_stmt->field_count
o
int$mysqli_stmt->insert_id
o
int$mysqli_stmt->num_rows
o
int$mysqli_stmt->param_count
o
string$mysqli_stmt->sqlstate
Methods
o
mysqli_stmt::__construct (mysqli $link, [string $query])
o
int mysqli_stmt::attr_get (int $attr)
o
bool mysqli_stmt::attr_set (int $attr, int $mode)
o
bool mysqli_stmt::bind_param (string $types, mixed &$var1, [mixed &$...])
o
bool mysqli_stmt::bind_result (mixed &$var1, [mixed &$...])
o
bool mysqli_stmt::close (void )
o
void mysqli_stmt::data_seek (int $offset)
o
bool mysqli_stmt::execute (void )
o
bool mysqli_stmt::fetch (void )
o
void mysqli_stmt::free_result (void )
o
mysqli_result mysqli_stmt::get_result (void )
o
object mysqli_stmt::get_warnings (mysqli_stmt $stmt)
o
mixed mysqli_stmt::prepare (string $query)
o
bool mysqli_stmt::reset (void )
o
mysqli_result mysqli_stmt::result_metadata (void )
o
bool mysqli_stmt::send_long_data (int $param_nr, string $data)
o
bool mysqli_stmt::store_result (void )
PHP Documentation Group MYSQLI_STMT(3)