The database does not currently support retrieval of procedure text.

The database does not currently support retrieval of procedure text. ...

Oracle How to get procedure text

What is the table from which we can get procedure text. My procedure became invalidated and I do not have the backup code. Oracle 8.1 ...

Oracle Viewing procedure text in SQLPLUSW

Is there any command to view the procedure text in SQLPLUSW (Like sp_helptext in SQLSERVER) other than quering dictionary views? ...

how to get the procedure text from PL/SQL prompt

is there any option to retrieve procedure text from PL/SQL prompt? you can access the procedure or trigger text using SP_HELPTEXT command in SQL Server. but in oracle PL/SQL, i couldn't find a command for that. however we can access the same through GUI tools which has been provided along with oracl ...

Search Stored Procedure Text

Ive been using the following code to search the bodies of all my stored procedures for a keyword:SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%foobar%' AND ROUTINE_TYPE='PROCEDURE' Its an extremely handy snippet, especially if you for ex ...

Oracle Stored Procedure Text

Where can one go using SQL*Plus to view the text of a stored procedure? ...

Oracle Data Dictionary View for Procedure Text

Is there a data-dictionary where I can see the body of procedures. In fact, I received a request from a collegue to give him the procedure name which access a table "table_1".So, my idea is to write a query as follows:SELECT <procedure_name> FROM <data_dictionary> WHERE <text> LIKE ...

Oracle Data-Dictionary for Procedure Text

Is there a data-dictionary where I can see the body of procedures. In fact, I received a request from a collegue to give him the procedure name which access a table "table_1".So, my idea is to write a query as follows:SELECT <procedure_name> FROM <data_dictionary> WHERE <text> LIKE ...

stored procedure text

How can I get the source code of the stored procedure from systables?I tried querying the sysprocbody, all that I'm getting in the data field is a bunch of unreadable characters with partial sql statements. I stumbled on to this before but cannot remember how I did it. Does anybody know? ...

Oracle View Procedure Text

Hai,I have a procedure in the database and suppose if I need to view the content of the procedure please let me know the steps to be done. ...

stmt text from Profiler

does anyone have a script that cleans up profiler traces by removing the variables from tsql. thereby giving you the procedure text as written. I saw this a few months ago and havent had any luck in finding it. anyone? ...

Table as argument into stored procedure

I want to write a stored procedure that can operate on different tables. I'm willing to do the work to make sure the tables have the correct fields, but I need to know if it's possible to pass the name (or other identifier) of the table into the procedure as an argument, and then select on that tabl ...

Retrieve multiple rows in stored procedure

I have a stored procedure that im trying to retrieve multiple rows.The stored procedure is:CREATE PROCEDURE SP_RETRIEVE_LISTINGS RETURNS (LISTINGID INTEGER,LISTING VARCHAR(60))ASbegin/* Procedure Text */forselect listing_id, listing from l_listingsinto :listingid, :listingdobeginsuspend;endendWhen i ...

stored procedure help

I'm trying to create a row-level stored procedure that takes an integer as an argument and based on that int it returns a certain string. I want to be able to use something like this:select my_proc(field1), field2, field3 from database. After reading some documentation about the subject I created a ...

One Question about NickName

I have a procedure which will operate two tables,one is local table, another is nickname for remote table in db2 db. i got a error when i invoked this procedure, error said "CLI DriverL:SQL30090N ....reason code:22,SQLState=25000"even if changed my code to :...Update local table set col1=valueif con ...

UDF SUBSTR dosen't work properly :(

so I have Firebird 1.5I want to create a SP to parse a string in order to result some numbers as records CREATE PROCEDURE PARSESTRING(INPUTSTRING VARCHAR(10000))RETURNS (ID INTEGER,STR VARCHAR(10),ALLSTRING VARCHAR(10000))ASDECLARE VARIABLE varStr VARCHAR(10000);DECLARE VARIABLE varIndex integer;dec ...

defncopy stored proc question

defncopy pulls just the stored procedure text. we have lot of procs that are using externally created hash tables [from parent proc or application ]. I am trying to build them with a different name [ say with a prefix ]. so defncopy does only part of the work, to build the proc, I need the hash tabl ...

Edit and Rich Edit Control + EM_SETSEL

I'm creating a plugin for Enterprise Manager's Stored Procedure dialog box to enable it to have "Find Text" capability.If you've seen this text box that contains the SQL Stored Procedure text, you'll know that it highlights certain key input text. So it's handling is slightly different tha ...

MySQL Stored Procedures being deleted

When I create a new Stored Procedure, it may replace an existing one. When I copy between Stored Procedures, the source procedure may be deleted. If I press Edit Stored Procedure and then press Cancel, the procedure may disappear. And Stored Procedures in another schema may disappear for no apparant ...

ODBC Problems with store procedures and Power Builder

I have problems to execute Store Procedures from Power Builder with 5,0 MySQL and MyODBC 3.51, it leaves the message: "The database does not currently support retrieval of procedure text" I see also that no longer MyODBC 5.0 exists, is possible to solve it with version 3.51? ...

Oracle Hoe to call dynamic PL/SQL from a Pro*C program?

I have a simple Pro*C program which calls a PL/SQL procedure. Procedure returns a reference to cursor. I want to pass procedure name as an argument to the Pro*C program at run time and execute the procedure.If I put actual name of the procedure it works fine but if I try to bind and execute the stat ...

Red Hat 9 install bombs at the very end - Help!

Please bear with me, I am a noob and I am trying to set up a small server to learn Linux and use as a pre-production server for web development.I have an old barebones box that I wanted to load Red Hat 9 onto. So I did the research on compatible hardware. My CPU is a K6-2 333Mhz, and my video card i ...

Powerbuilder 9.0 and mysql 5.0

I'm using powerbuilder 9.0 and when i tried to make a datawindow with a created stored procedure "The database does not currently support retrieval of procedure text." message appear. Whats this meaning? what can i do? ...

MySQL returning severals OUT variables

I cant seem to get mysql to return several variables using one SELECT statement, I've always used SET but this method doesnt work when returning more than 1 field: For example: CREATE PROCEDURE `sp_testme`( IN `strusername` varchar(30), OUT `productdesc` varchar(30), OUT `measuredesc` varchar(30) ) ...

Unable to insert data into SQL Database

I am facing a huge problem. I did a registration page and i want to store the data into SQL Server. I created two stored procedures in SQL and two functions in visual basic to call the stored procedures before inserting the data into the database. My codes are based on http://daniweb.com/tutorials/t ...

ASP.NET Registration Page

This is a continuation of the Updated: ASP.NET Login Page Tutorial.This tutorial will demonstrate how to create a registration page for new users to your site. This registration page will utilize the same principles used in the Login Page Tutorial, so this should be no more difficult to do than the ...

Oracle Escape operator

I want to search 'E' (whole thing including ' ) in database procedure/function text.I am writing query against user_text table to search 'E' by using escape character we can search for _,% but how can search for single quot ( ' ) in procedure text?Please how can I get this ?Reply SoonAvinash ...

Can't oracle save special characters copied from ms sql?

In our application when we copy-pasting some text in text area and trying to save that in database, same text is not getting saved. What we were trying to save is: “jjjjjjjjjjj’”*******!!`sachin, and what is getting saved is: ¿jjjjjjjjjjj¿¿*******!!`sachin. When I was trying to save the sam ...

Oracle Help Regarding sql*plus spool

I am trying to ready object data from one schema and compile that in another schema through sql*plus.I am trying to capture procedure data using spoll like bellow i am getting all procedure text but along with that i am getting my select statement also.i am using echo off but still getting is there ...

Oracle invalid path

i have written a procedure to get the output in excel file. but here i am getting error for invalid path.PROCEDURE TEXT ISA utl_file.file_type;S VARCHAR2(10000); CURSOR C1 IS SELECT * FROM EMP ORDER BY EMPNO;BEGIN A:=utl_file.fopen('c:\','emp.xls','W');FOR I IN C1LOOPutl_file.PUT_line(A,i.empno);end ...

Sql server User permisssion

i m working on sql server user permission i hv created sql server authentication user i need this user as read only can do1)only execute procedure but not able to view procedure text2)can only select,insert,update delete from tables but not able to view table designwhat permission should i give for ...

Writing text from db2 to the text file using sql procedure Builder

hai,I want the sql statements to write to a text file from DB2 sql stored procedure. We hae found solutions on the net using Java and C for the same which does not solve our problem. Please send me the reply for this problem.Kalyani ...

Oracle stored procedure API: does "TEXT" equal "CURSOR"?

I'm trying to call an Oracle stored procedure from Java. The API for the stored procedure has a couple of OUT parameters that are labeled type "TEXT," and it appears that each of these parameters has many subordinate parameters that are of simple types (varchar2, integer, etc.). Two questions:1. Do ...

read text file with db2 stored procedure

I want to know if it´s possible to read a text file using a db2 stored procedure?I konw how to make it using Oracle with the commands:vr_file := utl_file.fopen('e:\ftp_home\utl_dados', vr_arquivo, 'W'); -> open fileutl_file.get_line(vr_file, vr_linha); -> read lineutl_file.put_line(vr_file, v ...

for passing text type argument to procedure

For parsing data > 8000 char I have defined a procedure that looks something like create proc myproc @doc text as blah blah blah go but now i need to pass text argument to it. For that I need ::: declare @newdoc text and then call ::: exec myproc @newdoc but I cannot declare text type variable in ...

How to open a text file in a stored Procedure

Hai..I have data in text files ( not in csv format but in a properitary format).My requirment is to read the text files and parse it into corresponding data and then store it into the MSSQL Server Database.Is there any way to do this by using Stored Procedure or extended stored prodcedure in SQL Ser ...

how to see text of procedure

Can some one please tell me how to see the text or code of procedure.assume that i have procedure calculate sal.I want to view the code of that procedure for modification.. ...

Oracle Writing a text file from a stored procedure.

How can I write out data to a text file using a PL/SQL stored procedure? I have tried using the TEXT_IO package, but I am getting the error PLS-00201: identifier 'TEXT_IO.FILE_TYPE' must be declared. Please help.Thanks,Richard Kutrkut@velanvalve.com ...

Writing to a text file from Stored Procedure

Is it possible to write the output of a stored procedure toa text file. My requirement is to execute a oracle stored procedure and send the out put to a txt file or excel sheet. ...

Oracle Reading a Text file in Procedure

How do I read a Text file in reverse direction in PL/SQL Procedure. Every time I want to read last line in the file. Can I read last line without going through whole file? ...

How to extract the text of a stored procedure

Does any one have a Unix shell script to extract the text of a stored procedure from Oracle 8i/9i database and write it to a flat file on Unix machine so that I can compile that on another server using FTP ?Any help is really appreciated.Thanx..-Bheemsen ...

read text file with db2 stored procedure

Hello! I know that it´s a Oracle forum but, maybe there is somebody who can help me.I want to know if it´s possible to read a text file using a db2 stored procedure?I konw how to make it using Oracle with the commands:vr_file := utl_file.fopen('e:\ftp_home\utl_dados', vr_arquivo, 'W'); -> open ...

how to read the key, value pairs from the text file using stored procedure?

HiCan some one guide me how to read the key, value pairs from the text file using stored procedure?here I want to read the value from text file and i need insert into the table ...

Oracle Reading Text file & Updating table using PL SQL Procedure

Guys, I am trying to read data from a large text file which contains tab delimited data. Based on success of validations, I have to insert/update data in to table(s). Does any one has any sample procedure to read data (tab delimted/comma seperated) from a text file and write to database table? Your ...

Unhiding text of stored procedure

how to unhide the text of stored procedure?i hided stored procedure using sp_hidetext proc_namecan any on please tell me how to unhide the text. ...

Procedure to align syscomments text

Is there a procedure available to align the text column of syscomments table?I get the output as followscreate procedure pr_generate_textasbegindeclare @temp varchar(10)----------ENDBut I want the output to look like thiscreate procedure pr_generate_textasbegindeclare @temp varchar(10)----------END ...

How can I open an OS text file inside one Stored Procedure

I have one Operating System text file in some directory in UNIX environment . How can I open this file inside one Stored Procedure. ...

Oracle Create a text file output from within a procedure

I can output to a file from within SQL+ using the spool command but how do I do this from within a procedure?I have got a table called ABC and want to output columns A and B to a new text file based on variables pased through when the procedure is run, the name of the text file should be generated f ...

Oracle Create a procedure to print the result of a select into a text file

People,I need to create a procedure, and pass a SELECT statment as parameter, and the result of this select needs to be sent to a text file.Does someone have any idea on how I may do it? ...

Oracle TEXT datatype in Stored Procedure and concat Carriage returns

Anyone,I am trying to create a stored procedure that will allow me to grab a bunch of 255 Char records in a cursor and concatenate them together adding a carriage return after each row.Here is pseudo code would look like:CREATE OR REPLACE PROCEDURE myproc IS CURSOR c1 IS SELECT myVARCHAR_255_col Fro ...