DESIGNER Reverse Engineering ?
hello gurus, i would like know about the Reverse Engineering features of "ORACLE designer 6" i mean the level to which the Reverse Engineering feature goes has any one tried them out? i have reverse engineered the back end of a production database to "physical database design" using "Design Editor" and then to "logical database design" using " Entity Relationship Diagrammer " all the entities were saved to the repository. now what i would like to know is that can we Reverse Engineering the front end Application developed in ORACLE FORMS 6.0 (i mean the *.FMB files) to Data Flow Diagrams, Function Hierarchy Diagrams and Process Diagrams i now its hard to believe that DESIGNER can do this :0) automatically but i have read in one article from technet that says that DESIGNER can do this i mean "Full reverse engineering from FORMS " please share your experiences and knowledge on this topic with me TIA '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' Omar Khalid Software Engineer LMK Resources Voice: 111-101-101*780 Mobile: 0333-510-4465 Web: www.lmkr.com '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Connectivity problems through IIS server.
i have done this some time back . you need to setup the ODBC ADMINISTRATOR and make a DSN on the client side or the server side to access the oracle database using ASP. simply using the SQL NET won't work if u'r using ASP. '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' Omar Khalid Software Engineer LMK Resources Voice: 111-101-101*780 Mobile: 0333-510-4465 Web: www.lmkr.com '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' "shirish" .com>cc: Sent by: Subject: RE: Connectivity problems through IIS server. [EMAIL PROTECTED] om 07/20/2001 09:42 PM Please respond to ORACLE-L hi while connecting to oracle thro' ASP, u need to specify the TNSname. as far as i know the tnsname is case sensative(when using with ASP) so plz check the tnsname entry. also check the same with dsn entries.. hope this helps .. thanks and regards ! Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -Original Message- Behalf Of Naik, Sandesh S Sent: Thursday, July 19, 2001 8:10 PM To: Multiple recipients of list ORACLE-L Dear List, One of our developers is getting following error while trying to connect using IIS Server (4.0) to oracle Database 8.1.6.2.0. I think he is using ASP program to connect to database. I am able to connect though sqlplus.exe from that machine but not through the IIS Server connection. Is there anything else you have to set in IIS server to get right tnsnames.ora Can you help? The error message: Microsoft OLE DB Provider for Oracle error '80004005' ORA-12154: TNS:could not resolve service name /getdate.asp, line 33 Thanks Sandesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naik, Sandesh S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -- -- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: shirish INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you
Re: Data load options
hello O'Neill, Sean you can also use UTL_FILE Package provided by ORACLE to load data in to Oracle Database. if u'r Data Model is too complex then UTL_FILE Package is a better choice because it gives you lot of control for simple data loading SQL Loader is very efficient regards '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' Omar Khalid Software Engineer LMK Resources Voice: 111-101-101*780 Mobile: 0333-510-4465 Web: www.lmkr.com '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' "O'Neill, Sean"To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Data load options Sent by: [EMAIL PROTECTED] om 07/25/2001 06:16 PM Please respond to ORACLE-L I'm trying to compile a list of options for loading data into an Oracle database on NT platform. What I've come up with so far is: [1] SQL script that performs inserts, updates. [2] SQL Loader utility [3] Import utility Are there others? Anyone care to share experience based opinions on pros and cons of the methods? Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ER Diagram of a schema
hi dbabaiju you don't have to write queries to get info that would enable you to draw ER Diagram of a schema you can use TOOLS like ER-WIN or SCHEMA BUILDER to draw ER Diagram of a schema for you . i hope this solves your problem :) regards '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' Omar Khalid Software Engineer LMK Resources Voice: 111-101-101*780 Mobile: 0333-510-4465 Web: www.lmkr.com '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' "dbabaiju" times.com>cc: Sent by: Subject: ER Diagram of a schema [EMAIL PROTECTED] m 07/26/2001 08:35 PM Please respond to ORACLE-L --=_MAILER_ATTACH_BOUNDARY1_2001726417348324763920 Content-Type: text/plain; charset=us-ascii Hi guys, What queries to run on a schema to get info that would enable me to draw an ER Diagram of that schema ? Baiju Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy Music, Video, CD-ROM and Audio-Books from http://www.planetmonline.com --=_MAILER_ATTACH_BOUNDARY1_2001726417348324763920 Content-Type: text/html; charset=us-ascii Hi guys, What queries to run on a schema to get info that would enable me to draw an ER Diagram of that schema ? Baiju Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com";>http://email.indiatimes.comBuy Music, Video, CD-ROM and Audio-Books from http://www.planetmonline.com ">http://www.planetmonline.com --=_MAILER_ATTACH_BOUNDARY1_2001726417348324763920-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dbabaiju INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORACLE8i & cc compiler on SOLARIS
hello GURU DBAs i would like to know if cc compiler is required for installing ORACLE 8i on Solaris 2.6 or is the gcc compiler required? regards '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' Omar Khalid Software Engineer LMK Resources Voice: 111-101-101*780 Mobile: 0333-510-4465 Web: www.lmkr.com '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORACLE8i & cc compiler on SOLARIS
thank you all for your reply. i think i got it now :) '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' Omar Khalid Software Engineer LMK Resources Voice: 111-101-101*780 Mobile: 0333-510-4465 Web: www.lmkr.com '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' "Guy Hammond" vt.co.uk>cc: Sent by: Subject: RE: ORACLE8i & cc compiler on SOLARIS [EMAIL PROTECTED] om 07/30/2001 05:25 PM Please respond to ORACLE-L Doh! What I meant to say was, you do not need a compiler but you do need /usr/ccs/bin in your $PATH before you can re-link Oracle binaries, for example after installing a patch. g -Original Message- Sent: Friday, July 27, 2001 1:51 PM To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SUMMARY: Re: ORACLE8i & cc compiler on SOLARIS
hi all this is the summary of my findings on the question "is cc Compiler is required for installing ORACLE 8i on Solaris 2.6' Solaris ships in with every thing you need, with the exception of the cc Compiler itself. Solaris ships with the include files, make,an assembler,linker and libraries. all this stuff lives in /usr/ccs/bin so add this to your path . if you do not have a cc compiler installed on you machine when you are installing ORACLE 8i regards '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' Omar Khalid Software Engineer LMK Resources Voice: 111-101-101*780 Mobile: 0333-510-4465 Web: www.lmkr.com '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' =?x-user-defined?Q?B=FClent=20A=E7= FDkg=F6z?= <[EMAIL PROTECTED]> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] cc: Subject: Re: ORACLE8i & cc compiler on SOLARIS 07/31/2001 04:20 PM Please respond to ORACLE-L [EMAIL PROTECTED] wrote: > thank you all for your reply. i think i got it now :) > > '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' > Omar Khalid > Software Engineer > LMK Resources > Voice: 111-101-101*780 > Mobile: 0333-510-4465 > Web: www.lmkr.com > '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' > > > > > > > > > > > "Guy Hammond" > > vt.co.uk> cc: > Sent by: Subject: RE: ORACLE8i & cc compiler on SOLARIS > [EMAIL PROTECTED] > om > > > 07/30/2001 > 05:25 PM > Please respond > to ORACLE-L > > > > Doh! > > What I meant to say was, you do not need a compiler but you do need > /usr/ccs/bin in your $PATH before you can re-link Oracle binaries, for > example after installing a patch. > > g > > -Original Message- > Sent: Friday, July 27, 2001 1:51 PM > To: Multiple recipients of list ORACLE-L > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). Hi omar Can you summary this problem? thank you. (See attached file: bacikgoz.vcf) =?iso-8859-1?Q?bacikgoz.vcf?=
Re: How to send email from pl/sql in 806?
try this procedure it works just replace the IP address in the line
c := utl_tcp.open_connection('192.168.1.1', 25);
with the IP address of u'r mail server
regards
__
Omar Khalid
Software Engineer
LMKResources
A LANDMARK AFFILIATE
(Formerly Mathtech Pakistan Pvt. Ltd)
18, F-8/3, Main Margalla Road,
Islamabad, Pakistan
Voice: 111-101-101*780
Fax: 92-051-2255989
Email: [EMAIL PROTECTED]
Web: www.lmkr.com
rem ---
rem Filename: smtp.sql
rem Purpose:Send e-mail messages from PL/SQL
rem Notes: From Oracle8i release 8.1.6 one can send e-mail messages
rem directly from PL/SQL using either the UTL_TCP or UTL_SMTP
rem packages. No pipes or external procedures required.
rem Date: 27-Mar-2000
rem Author: Frank Naude ([EMAIL PROTECTED])
rem ---
CREATE OR REPLACE PROCEDURE SEND_MAIL (
msg_fromvarchar2 := 'oracle',
msg_to varchar2,
msg_subject varchar2 := 'E-Mail message from your database',
msg_textvarchar2 := '' )
IS
c utl_tcp.connection;
rc integer;
BEGIN
c := utl_tcp.open_connection('192.168.1.1', 25); -- open the SMTP
port 25 on local machine
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'HELO 192.168.1.1');
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'MAIL FROM: '||msg_from);
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'RCPT TO: '||msg_to);
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'DATA'); -- Start message
body
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'Subject: '||msg_subject);
rc := utl_tcp.write_line(c, '');
rc := utl_tcp.write_line(c, msg_text);
rc := utl_tcp.write_line(c, '.');-- End of message
body
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
rc := utl_tcp.write_line(c, 'QUIT');
dbms_output.put_line(utl_tcp.get_line(c, TRUE));
utl_tcp.close_connection(c); -- Close the
connection
EXCEPTION
when others then
raise_application_error(-2,'Unable to send e-mail message from
pl/sql');
END;
/
show errors
-- Examples:
set serveroutput on
exec send_mail(msg_to =>'Omar Khalid/IT/LotusCert/Pk');
exec send_mail(msg_to =>'[EMAIL PROTECTED]');
exec send_mail(msg_to =>'[EMAIL PROTECTED]',
msg_text=>'Look Ma I can send mail from plsql');
Oracle DBA
o.com> cc:
Sent by: Subject: How to send email from pl/sql in
806?
[EMAIL PROTECTED]
om
05/23/2001
11:35 AM
Please respond
to ORACLE-L
Hi,
I am aware that 817 supports UTL_SMTP for this same
functionality. But how can one send email from p
Re: How to send email from pl/sql in 806?
hi saurabh
nops utl_http will not help it's a different procedure
here is the code in utltcp.sql file
hope it solves u'r problem
__
Omar Khalid
Software Engineer
LMKResources
A LANDMARK AFFILIATE
(Formerly Mathtech Pakistan Pvt. Ltd)
18, F-8/3, Main Margalla Road,
Islamabad, Pakistan
Voice: 111-101-101*780
Fax: 92-051-2255989
Email: [EMAIL PROTECTED]
Web: www.lmkr.com
REM Copyright (c) 1999 by Oracle Corporation.
REM
REM NAME
REMutltcp.sql - PL/SQL Package for TCP/IP communication
REM (Package Specification of UTL_TCP)
REM
REM DESCRIPTION
REMRoutines to perform TCP/IP communication.
REM
REM NOTES
REMThe procedural option is needed to use this package.
REMThis package must be created under SYS.
REM
REM MODIFIED (MM/DD/YY)
REM jmuller 09/16/99 - Fix bug 708690: final pass
REM rpang 08/11/99 - Added constants for error codes
REM rpang 07/28/99 - Added BAD_ARGUMENT exception
REM rpang 05/14/99 - Created
CREATE OR REPLACE PACKAGE utl_tcp AS
/***
* OVERVIEW
*
* This package provides TCP/IP client-side access functionality in
PL/SQL.
* With this package, a PL/SQL program can communicate with external
TCP/IP
* services and retrieve data. The API only allows connections to be
* initiated by the PL/SQL program. It does not allow the PL/SQL program
* to accept connections initiated from outside of the program.
*
* USES
*
* A TCP/IP connection is initiated by a call to open_connection, which
* returns a TCP/IP connection. Text and binary data can be sent or
* received on the connection. It is also possible to look ahead at the
* data before it is actually read. The connection is terminated by
* a call to close_connection.
*
* EXAMPLES
* Retrieve the home page from http://www.acme.com/
*
* DECLARE
* c utl_tcp.connection; -- TCP/IP connection to the Web server
* BEGIN
* c := utl_tcp.open_connection('www.acme.com', 80); -- open
connection
*
* utl_tcp.write_line(c, 'GET / HTTP/1.0'); -- send HTTP
request
* utl_tcp.write_line(c);
* BEGIN
* LOOP
* dbms_output.put_line(utl_tcp.get_line(c, TRUE)); -- read
result
* END LOOP;
* EXCEPTION
* WHEN utl_tcp.end_of_input THEN
* NULL; -- end of input
* END;
* utl_tcp.close_connection(c);
* END;
*/
/*
* TCP connection type
*/
TYPE connection IS RECORD (
remote_host VARCHAR2(255), -- Remote host name
remote_port PLS_INTEGER, -- Remote port number
local_hostVARCHAR2(255), -- Local host name
local_portPLS_INTEGER, -- Local port number
charset VARCHAR2(30),-- Character set for on-the-wire comm.
newline VARCHAR2(2), -- Newline character sequence
private_sdPLS_INTEGER, -- For internal use only
private_bfRAW(32767), -- For internal use only
private_bfsz PLS_INTEGER, -- For internal use only
private_pos PLS_INTEGER, -- For internal use only
private_end PLS_INTEGER, -- For internal use only
private_mkpos PLS_INTEGER -- For internal use only
);
/*
* Carriage-return line-feed character sequence.
*/
CRLF CONSTANT VARCHAR2(10) := chr(13) || chr(10);
/*
* Exceptions
*/
buffer_too_small EXCEPTION; -- Buffer is too small for I/O
end_of_input EXCEPTION; -- End of input from the connection
network_error EXCEPTION; -- Network error
bad_argument EXCEPTION; -- Bad argument passed in API call
buffer_too_small_errcode CONSTANT PLS_INTEGER:= -2;
end_of_input_errcode CONSTANT PLS_INTEGER:= -20001;
network_error_errcodeCONSTANT PLS_INTEGER:= -20002;
bad_argument_errcode CONSTANT PLS_INTEGER:= -20003;
PRAGMA EXCEPTION_INIT(buffer_too_small, -2);
PRAGMA EXCEPTION_INIT(end_of_input, -20001);
PRAGMA EXCEPTION_INIT(network_error,-20002);
PRAGMA EXCEPTION_INIT(bad_argument, -20003);
/**
* Opens a connection to a TCP/IP service. When connection is made
* succesfully, the remote host name and remote port number will be
stored in
* the connection. If local_host, local_port or charset is specified,
* it will be stored in the connection as well.
*
* PARAMETERS
* remote_host remote host name to connect to
* remote_port remote port number to connect to
* local_host local host name to connect from
* local_port local port number to connect from
* in_buffer_size input buffer size
* out_buffer_size output buffer size
* charset character set for on-the-wir
