learn unix and linux commands

Debugging PL/SQL from .NET

10 More Discussions You Might Find Interesting

1. Homework & Coursework Questions

Debugging Help Needed

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! I am VERY much a neophyte with shell scripting. I am working on the following, 1. The problem statement, all variables and given/known data: "Create a script sends an...

2. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

Hi All, I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise. Eg : Select 'Query 1 output' from dual; Select 'Query 2 output' from dual; I want to...

3. Programming

c++ debugging

hey i have a problem with a switch case in program and the debugger is messy has hell ( we use normal VI and gdb in our schoool to make it more diffiacult) any way i have a problom where for some unknown reason the debugger just skips a switch statment as if it wasent even there the rest...

4. UNIX for Advanced & Expert Users

Call parallel sql scripts from shell and return status when both sql are done

Hi Experts: I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing...

5. Shell Programming and Scripting

Execute multiple SQL scripts from single SQL Plus connection

Hi! I would like to do a single connection to sqlplus and execute some querys. Actually I do for every query one connection to database i.e echo 'select STATUS from v$instance; exit' > $SQL_FILE sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT echo 'select VERSION from v$instance;...

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

7. Shell Programming and Scripting

Net::SSLeay or Net::FTPSSL

Hello, I ran into an issue in one of my monitoring scripts. If I use the public ip address in my connection string everything works, but if I switch the connection string ip to 127.0.0.1 or the internal ip I get, " Connection refused at...

8. Solaris

debugging

when I tried to debug my application i got the following. gdb -v GNU gdb 6.6 file is in C and Xmotiff Languages (gdb) attach 25499 Attaching to process 25499 Retry #1: Retry #2: Retry #3: Retry #4: 0xfea40b68 in ?? () (gdb) where #0 0xfea40b68 in ?? ()

9. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Hi- I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment... I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert...

10. Shell Programming and Scripting

Regarding Debugging

Hi, If we want to debug a shell script, then set -vx has to be included in the begining of the script. Just i want to know what purpose -vx is used. Thanks in advace Sarwan

LEARN ABOUT DEBIAN

alzabo::debug

Alzabo::Debug(3pm)					User Contributed Perl Documentation					Alzabo::Debug(3pm)

NAME

       Alzabo::Debug - Creates constants used to turn on debugging

SYNOPSIS

	 export ALZABO_DEBUG='SQL|TRACE'

	 ... load and run code using Alzabo ...

	 export ALZABO_DEBUG=METHODMAKER

	 ... load and run code using Alzabo ...

DESCRIPTION

       This module creates constants used by other modules in order to determine what debugging output should be generated.

       The interface is currently experimental.

USAGE

       Currently, the only way to turn on debugging is by setting the "ALZABO_DEBUG" environment variable.  This variable can contain various
       flags, each separated by a pipe char (|).  Each flag turns on different types of debugging output.

       These flags must be set before Alzabo is loaded, as debugging is turned on or off through the use of constants.

       The current flags are:

       * SQL
	   Generated SQL and its associated bound variables.

       * TRACE
	   A stack trace will be generated any time SQL is generated.

       * METHODMAKER
	   The "Alzabo::MethodMaker" module will generate verbose output describing the methods it is creating.

       * REVERSE_ENGINEER
	   The modules involved in reverse-engineering will generate output describing what it finds during reverse-engineering.

       * ALL
	   Turn on all flags.

       For now, all debugging output is sent to "STDERR".

perl v5.8.8							    2007-12-23							Alzabo::Debug(3pm)