Blogs about: Ref Cursor

Featured Blog

Getting APEX to play with Ref Cursors

It’s that time of year again. Things are a bit tense around the house. The other morning, I woke up to find that someone had placed a leek in my slippers. Yes it’s Six Nations time again.… more →

The Anti-Kyte

Ref Cursors Oracle

sqlandplsql wrote 1 month ago: The REF CURSOR is a data type in the Oracle. REF CURSOR also referred as Cursor Variables.Cursor var … more →

Tags: PL/SQL, Oracle, ref cursors, refcursor, reference cursor, cursor variable, Weak and Strong ref cursor

HOW TO CHECK IF A REF CURSOR RETURNS DATA FROM A PL/SQL PROCEDURE

doganay wrote 4 months ago: create or replace procedure sp_is_refcursor_null (v_cursor OUT SYS_REFCURSOR) AS v_rec number; BEGIN … more →

Tags: Oracle, PL/SQL, Cursor, procedure, HOW TO CHECK IF A REF CURSOR RETURNS DATA FROM A PL/SQL, Ref_cursor, Ref

Working with REF Cursors - With Examples

Dibyajyoti Koch wrote 8 months ago: A ref cursor is a variable, defined as a cursor type, which points to, or references a cursor result … more →

Tags: SQL & PL/Sql, Normal Cursor Vs. Ref Cursor, PL/SQL, REF CURSOR WITH %ROWTYPE, REF CURSOR WITH %TYPE, REF CURSOR WITH RECORD TYPE

Calling and exiting SQLPlus from a DOS batch file dynamically

Ronald wrote 8 months ago: Suppose you want to run a SQL*Plus script from a DOS batch file. The SQL*Plus script does not contai … more →

Tags: Oracle, SQL, MS DOS, DOS, batch, SQL*Plus, Script

Fetch from a refcursor returned by a function or stored procedure

Ronald wrote 11 months ago: My web application accesses the database using packages. These packages contain procedures that retu … more →

Tags: Oracle, SQL, PL/SQL, recursor, procedure, function

Getting APEX to play with Ref Cursors — 6 comments

mikesmithers wrote 1 year ago: It’s that time of year again. Things are a bit tense around the house. The other morning, I wo … more →

Tags: PL/SQL, SQL, Oracle, OraDBPedia Syndication, APEX 4.1, create type as object, PIPELINED Functions, sys_refcursor, weakly typed ref cursor

Ref Cursors

ritusri wrote 1 year ago: Just wondering from sometimes that why the hell we have one more cursor type called as ref cursor wh … more →

Tags: technical, ref cursor vs normal cursor

The power of REF CURSOR types — 3 comments

lukaseder wrote 1 year ago: Many RDBMS have started implementing support for some sort of CURSOR, REF CURSOR or ARRAY/TABLE type … more →

Tags: SQL, Array, nested tables, Stored Functions, unnest

Copying/Transforming a REF CURSOR in Oracle 10g+ — 2 comments

ellebaek wrote 2 years ago: Introduction Use case: You need to be able to copy and optionally transform any PL/SQL REF CURSOR in … more →

Tags: Oracle PL/SQL, Copy, Oracle, Transform

Describing a REF CURSOR in Oracle 10g+ Using PL/SQL, Java and C — 1 comment

ellebaek wrote 2 years ago: Introduction Use case: You need to be able to describe any PL/SQL REF CURSOR in a uniform way across … more →

Tags: JDBC, oracle call interface, Oracle PL/SQL, c external procedure, describe, java resultset, java stored procedure, Oci, Oracle

Object Relational Features of Oracle user defined types(UDT) and Csharp.NET — 1 comment

serkanbalci wrote 2 years ago: Object Relational Features of Oracle; user defined types(UDT) and Csharp.NET In this article I am go … more →

Tags: Oracle and C#.NET, UDT, user defined types, dynamic sql, oracle object, ödp, ODP Net, UdtTypeName, ommandType.StoredProcedure

Calling Oracle packages from CSHARP.NET with ref cursor

serkanbalci wrote 2 years ago: Calling Oracle packages from CSHARP.NET with ref cursor I think you heard about the terms of ORACLE … more →

Tags: Oracle and C#.NET, .NET Framework, Programming, SQL, Source Code, select sql, Oracle, Databases, Google

Taking the bind out of mid-tier queries

mikesmithers wrote 2 years ago: At least it wasn’t penalties. Another straw to clutch at – to paraphrase George W Bush – the G … more →

Tags: PL/SQL, SQL, Oracle, dynamic sql, bind variables, hard parse, v$sqlarea, PLS-00455

Cursors in Oracle

Dibyajyoti Koch wrote 2 years ago: CURSORS: A cursor is a mechanism by which you can assign a name to a “select statement” … more →

Tags: SQL & PL/Sql, Cursors, PL/SQL, Explicit Cursors, Implicit Cursors, Declaring the cursor, Opening the cursor, Fetching the cursor, Closing the cursor

How to use Ref Cursor example

Tamim Khan wrote 3 years ago: How to use Ref Cursor example A REF CURSOR is basically a data type.  A variable created based on su … more →

Spring + iBatis // Oracle Ref Cursors

Alastair Vance wrote 3 years ago: The previous iBatis example on this blog was for simple embedded SQL queries.  The following example … more →

Tags: ibatis, java language, spring, Oracle, OUT, parameter

Reference Cursors - Why, when, and how? — 3 comments

maclochlainn wrote 4 years ago: Quick Update: I move the blog because folks told me the screen shots weren’t as useful as copi … more →

Tags: Oracle, sys_refcursor, weakly typed reference cursors, strongly typed reference cursor, system reference cursor


Related Tags
All →

Follow this tag via RSS