SUMMARY: Re: ORACLE8i & cc compiler on SOLARIS

2001-07-31 Thread okhalid
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.

RE: ORACLE8i & cc compiler on SOLARIS

2001-07-30 Thread okhalid
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 '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'

ORACLE8i & cc compiler on SOLARIS

2001-07-27 Thread okhalid
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 '_-

Re: ER Diagram of a schema

2001-07-26 Thread okhalid
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 Sof

Re: Data load options

2001-07-25 Thread okhalid
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 '_-_'_-_'_-_'_

RE: Connectivity problems through IIS server.

2001-07-22 Thread okhalid
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 LM

DESIGNER Reverse Engineering ?

2001-07-09 Thread okhalid
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 Ed

Re: How to send email from pl/sql in 806?

2001-05-25 Thread OKhalid
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

Re: How to send email from pl/sql in 806?

2001-05-22 Thread OKhalid
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