devxlogo

Tip Bank

Using views to improve performance

Question: We are building a Web-based interface for an existing database. We’reusing a SQL interpreter that runs the queries, then sends them to theserver without the need for a client

How can I write to OS files from Oracle?

Question: How can I write to OS files from Oracle? Answer: Oracle version 7.3 supports directreading and writing of operating system files from within Oracle.In particular, the utl_file package enables

How can I send email from Oracle?

Question: How can I send email from Oracle? Answer: A recurring question on Oracle developer listsis how to send email from “within” Oracle. One might want a certain event in

Rich text presentation style

Question: When using a rich text datawindow (not an rte control), is there a way to save the contents to a file as rich text, as is? In other words,

Referencing instances of classes

Question: How do classes communicate? If class A created one or more instances of class B and class C, how can class A keep track of all the instances of

OPO and stored procedure parameters

Question: Stored procedure on WG7.3 Oracle expects three parameters. I can get OPO 2.0 to pass the params if I cite them literally as, for example, exec sql begin addnewperson(‘John’,’Quincy’,’Doe’);