.sql file in perl

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Pass perl array to SQL oracle

Hello, Could someone please suggest if there is a way to pass an perl array(pass @v_array) to SQL as in below eg : #!/usr/bin/perl @v_array = (1,2,4,5,6,8); $db_userid = 'ni71/ni711'; $bufTPO = qx{ sqlplus -s << EOF $db_userid set verify off set feedback off set...

2. Shell Programming and Scripting

Perl with Sql Server2005

Hi all, I am getting an issue in connecting perl with sql server 2005. I am unsing Padre as an IDE on Strawberry perl. Please help me about this matter

3. Shell Programming and Scripting

perl- oracle sql query

Hi, I am new to perl.How to query oracle database with perl??? Thanks

4. Shell Programming and Scripting

PERL : Bind 2D array to SQL

Hi, I am in the need of doing a bulk insert via : SQL - INSERT INTO <table> (SELECT..) OR PLSQL Block - FORALL i IN 1 .. count INSERT INTO <table>(arrayname(i)) I have a 2D array in my perl code which has the rows to be bulk inserted. Is there a way to bind the 2D array to the SQL...

5. Shell Programming and Scripting

run sql query via perl script

Hello, If I run this command on the server it works. # dbc "update config set radio_enabled = 0;" how can I execute the same command in perl. I have defined the dbc path. Can any one please correct the last line. #!/usr/bin/perl #database path $dbc='/opt/bin/psql -Userver...

6. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s...

7. Shell Programming and Scripting

Reading PL/SQL output online from perl??

Hi there, I got this situation at job. First i have a Perl script that connect to Oracle 10g and execute a package. That package execute severals transactions and must generate log about process status each interval of time. What i'm doing now is saving the plsql package log in an auxiliar...

8. Shell Programming and Scripting

Need help in printing a sql query in perl

Hi All, I have the following sql query select abcd from udbadm.log where xyz='1'. I have 16k queries similar to this with different values for xyz. I want to print the values of 'abcd' for each row. I have the following perl code, but not sure how i can print that particular...

9. 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...

10. Shell Programming and Scripting

Incorrect SQL query in perl

I the the following perl script, however it does not return anything. Did i form my syantax wrongly? $sth=$dbh->prepare("select a.rowid,a.* from Table1 a where a.field1 = \'$Indicator1\' and a.schedule = \'$Indicator2\' and a.lastdate <= sysdate"); $sth->execute() ...

LEARN ABOUT PHP

mssql_next_result

MSSQL_NEXT_RESULT(3)													      MSSQL_NEXT_RESULT(3)

mssql_next_result - Move the internal result pointer to the next result

SYNOPSIS

       bool mssql_next_result (resource  $result_id)

DESCRIPTION

	When  sending more than one SQL statement to the server or executing a stored procedure with multiple results, it will cause the server to
       return multiple result sets. This function will test for additional results available form the server. If an additional result  set  exists
       it will free the existing result set and prepare to fetch the rows from the new result set.

PARAMETERS

	      o $result_id
		- The result resource that is being evaluated. This result comes from a call to mssql_query(3).

RETURN VALUES

	Returns TRUE if an additional result set was available or FALSE otherwise.

EXAMPLES

       Example #1

	      mssql_next_result(3) example

	      <?php
	      // Connect to MSSQL and select the database
	      $link = mssql_connect('MANGOSQLEXPRESS', 'sa', 'phpfi');
	      mssql_select_db('php', $link);

	      // Send a query to MSSQL
	      $sql = 'SELECT [name], [age] FROM [php].[dbo].[persons]';
	      $query = mssql_query($sql, $link);

	      // Iterate through returned records
	      do {
		  while ($row = mssql_fetch_row($query)) {
		      // Handle record ...
		  }
	      } while (mssql_next_result($query));

	      // Clean up
	      mssql_free_result($query);
	      mssql_close($link);
	      ?>

PHP Documentation Group 												      MSSQL_NEXT_RESULT(3)

UNIX for Dummies Questions & Answers