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

jQuery Text not displaying in a dialog

I'm encountering a strange problem with dialogs. Where any text put inthe <div> simply doesn't appear when the dialog is opened. The codebelow suffices for illustrating the problem.Code:$('#confirm-delete').dialog({modal: true,close: function() {$('#confirm-delete').dia ...

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

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

Examples of various MIME emails

Can someone give me links to collection of samples of MIME emails in various formats? Of course I have already found examples of text/plain and text/html; but it is hard to find others. I am especially interested in text/* and application/* examples. ...

Textarea POST PHP error if text contains "CD/"

I have a HTML page with a textarea that uses POST to send the contents to a PHP page. The second page simply updates a MySQL database with the contents of the box (pretty standard). However the second page completely freezes and returns 404 if the text entered contains the letters "cd" in ...

help making entry confirmation page

Hi, I am trying to make an entry confirmation form. This is going to be used as a disclaimer for my website. How can I make this to where it only shows on the main page and not every page a user goes to on my website?<script>var enter=confirm("examples insert text")if (!enter)window. ...

I'm feeling wrapped...

Wondering if any1 could help me out here,I tried a lot of times to use wordwrap, but for some reason it failed over and over again, so I searched the manual, and used the examples from the wordwrap function-list,and guess what they didn't work either, just a straight line as a result...Could any1 ex ...

Not Displaying HTML in forms

I have seen examples of text input forms whereby the sent value is HTML formatted, but the seen value is as it would be in a browser...I am writing a lot of forms for my community based site, and this would be a great feature for my *HTML dumb* audienceI've searched thoroughly, but only found WYSIWY ...

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

Basic PHP

I just want the PHP to be able to create and manipulate a MySQL table. The code for accessing the server and opening the database I have already. I just have two columns (textCL and infoCL). Each column has only one row. I need textCL to be MEDIUMTEXT and infoCL to be TINYTEXT. Both will vary in siz ...

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

preg_match mayb?

i have two varibles. $text is a line of a file$query is a string passed from a html formexamples are$text="the quick brown fox"$query="he row"i want to know if all words in $query are contained in $textany hints? Stephen ...

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

Online Quiz System

everyone. I am trying to write a quiz for a site. Questions are in multiple choice, true/false, fill in the blank etc. The example questions i have can be seen below.I'm trying to plan how am I going to code this. I was thinking of having a table with two columns one with questions and one with answ ...

Legal Copyright Header

I am trying to formulate a legal copyright header for proprietary software source codes within our development process. I would like to provide several examples or text suggestions before these will be reviewed from the legal department.Is anyone aware of any available online guidance or literature ...

PHP DOM function to parse HTML data source as if csv.

I am trying to understand a PHP DOM function I found to parse a HTML data source. It is close to what I need but I need to understand and adjust it.I have the following as a data source format I can't change.<html><body><table><tr><th>header1</th><th>header2 ...

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

Error exporting report

HelloI've developed an ASP.NET WebApplication (VS.NET 2002) with some Crystal Reports in it to report the data.This reports are automatically exported into a pdf-File (using the Report.Export function)To give the user the ability to change the language of the WebApp, all the texts are stored in a MS ...

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 How to Parse a Database Field that's delimited optional Enclosures

Need help on writing a parse routine for a text field that's delimited with optional enclosures.I have a Parse function that works fine with separating a text field that comma delimited into separate elements within a type table fields.Now I want to expand it to pass in Enclosure Start and End param ...

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

Oracle Producing text file from PL/SQL procedure (UTL_FILE)?

I need to produce a text file from a PL/SQL procedure. My output should be a little over 38K records and my query has 70 fields. I'd like to separate the fields by pipe delimiters in the text file. I can either concatenate all 70 fields into one variable for each record or send all 70 fields over wi ...

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

cloudscape java stored procedure examples and error messages

Thanks again for releasing Cloudscape as open-source.Firstly, would it be possible to provide an example of creation and use of java stored procedures from within cloudscape? I'm struggling and there appears very little documentation on the subject, and certainly no end-to-end examples (starting fro ...

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