PL/SQL lets you issue a query and return a result set using a cursor variable, also known as a REF CURSOR. See "Using Cursor Variables (REF CURSORs)".

Visual Basic (VB) is a very popular event driven programming language developed by Microsoft. Visual Basic (VB) programming allows the user to create custom programs like our Excel macros or a custom Excel template. With the power and flexibility of Visual Basic, Excel and other Microsoft Office applications can become much more efficient.

It's a subset of Visual Basic 6. We've left out some of the advanced features to make it easier to get started with and use. The result is still a very rich and complete language. See the NS Basic/Desktop Specifications for a list of statements and functions supported. It's pretty easy to take most VB projects and convert them to NS Basic/Desktop. Compared to VB.NET, NS Basic/Desktop is much easier to get started with. It also does not have the runtime enviroment requirements that .NET has.

I am using referral (referer) protection however, with MPEGS, WMV's and pdf's it does not work - users are denied access, and with printing CSS I have the same problem.

Note that Oracle is committed to continuing support and development of PL/SQL - there is no reason to convert PL/SQL into Java for future compatibility. Also, PL/SQL and Java are fully interoperable: you can call PL/SQL stored procedures from Java using JDBC or SQLJ and vice versa. There are third-party products (for example from Quintessence Systems http://www.in2j.com) that provide for an automated migration from PL/SQL to Java.

When VB source is compiled to Native Code the result is x86 machine code and in the process the VB compiler with its various code optimisation features erases much of the structure of the high level Basic language. It's a formidable job to try to reverse engineer this x86 code back into VB code and it's not at all clear to us that it's possible to automate the reversing process.

Many programmers code their Java classes (see #9 above) using the Editor that is supplied with their Operating Systme (I use Windows Notepad myself). The Java Development Kit (JDK) that you download from Sun Microsystems does not come with an IDE per se--but you can download one for free from Sun called Forte, and there are some other free ones available. In addition, there are other IDE's available for purchase.

Those acronyms refer to various features such as programming languages, databases, etc. that might be available with a hosting plan. Please check out our Glossary for definitions.

Assuming that you have successfully installed C-Sharpener For VB, the menu option should automatically appear. If it doesn't appear, then try the following: Turn on the checkbox to the left of C-Sharpener For VB and click the OK button. The menu option should now appear.

J. Henshaw asks "Is it possible to run both VB6 and VB.Net on the same machine,or do I have to remove VB6 to be able to use VB.NET", and the answer is a definite yes. You can run them both on the same machine. Many people, including myself, run VB6 on the same machine as their installation of Visual Basic .NET. If you look at this KB article from Microsoft Support, you will even see that it recommended to run VB6 and VB.NET on the same machine when upgrading projects from one to another.

Both PL/SQL and Java can be used to create Oracle stored procedures and triggers. This often leads to questions like "Which of the two is the best?" and "Will Oracle ever desupport PL/SQL in favour of Java?". Many Oracle applications are based on PL/SQL and it would be difficult of Oracle to ever desupport PL/SQL. In fact, all indications are that PL/SQL still has a bright future ahead of it. Many enhancements are still being made to PL/SQL.

Space: The overhead of running Java in a database session is a couple of tens of kBytes per session in addition to any memory that is used directly by the Java program. Time: Every connection (database session) that you establish, requires a one-time startup time for the JavaVM (and for the SQLJ runtime, see also Performance of Java and SQLJ in Stored Procedures).

No. Visual Basic is a purely Microsoft standard and is not available for Unix. VB will probably never be widely used in the Unix community where there are thought to be far better object oriented languages available. There is however one product to convert VB code into java and and run active server pages: Halcyon Software <http://www.vbix.com/>. Python, for example, is an object oriented scripting language said to far exceed VB.

Why do I get the error 'Cannot use file <logfile> because it was originally formatted with a different sector size

No. It is not feasible for Oracle JDBC drivers to support calling arguments or return values of the PL/SQL types TABLE (now known as indexed-by tables), RESULT SET, RECORD, or BOOLEAN. There are currently no plans to change this. Instead people are encouraged to use RefCursor, Oracle Collections and Structured Object Types.

Latest Answer: Hi All,I am new to this community. It seems the question is related to Begin End block of PL/SQL. Se... Latest Answer: You must be speaking about PLS_INTEGER. PLS_INTEGER, uses machine-arithmetic unlike BINARY_INTEGER... Latest Answer: DESC will display the values in DESCending order when used in an ORDER BY clause.For example:SELECT ... Latest Answer: In hash join hash table gets build using the inputs. Nested loops as the name implies uses looping c..

By default, you put an exception handler at the end of a subprogram to handle exceptions that are raised anywhere inside the subprogram. To continue executing from the spot where an exception happens, enclose the code that might raise an exception inside another BEGIN-END block with its own exception handler. For example, you might put separate BEGIN-END blocks around groups of SQL statements that might raise NO_DATA_FOUND, or around arithmetic operations that might raise DIVIDE_BY_ZERO.

The DriverManager class is a core part of the java.sql package for Java database connectivity, it provides a registry of JDBC drivers that are loaded and available for use, and methods to get database connections using those drivers. The JDBC specification requires implementations of the java.sql.Driver interface to register themselves with the DriverManager method registerDriver(Driver) when their class is loaded through the Class.forName(String) method.

SQL is a limited language that allows you to directly interact with the database. You can write queries (SELECT), manipulate objects (DDL) and data (DML) with SQL. However, SQL doesn't include all the things that normal programming languages have, such as loops and IF...THEN...ELSE statements. PL/SQL is a normal programming language that includes all the features of most other programming languages.