Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SOURCE tables

SOURCE tables

From: Steve Sochacki <steve.sochacki_at_exmi01.exch.eds.com>
Date: 1997/11/21
Message-ID: <01bcf674$838fa640$b42fe4c7@SAMHC180.sys.eds.com>#1/1

This could be a dumb question, but here's what's happening. I'm trying to extract the source for stored procedures (SP). In Visual Data Tools, I see the whole SP with the first statement being Create or Replace Procedure xxxxx. When I run a query selecting the TEXT Varchar(2000) from DBA_SOURCE or ALL_SOURCE the first statement is just 'Procedure xxxxx' and the TEXT looks like it's cut off after about 75 characters and I'm losing characters. Any help would be appreciated. Received on Fri Nov 21 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US