python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - plsql-package

How to get multiple rows in Case Then clause

I want to write the case expression for this condition in View Indicate "Y" in the report if Livestream (all) is selected and display all the individual platforms under livestream (App, Onli...
test-img

ARH

sql

plsql

case

plsqldeveloper

plsql-package

Votes: 0

Answers: 1

Latest Answer

A simple option - if it is OK with you - is to use the INSTR function. Something like this: Sample data: SQL> select * from test; TREE_ID DESCRIPTION PRENT_NODE_ID ---------- --------...
test-img

Littlefoot

we have g_errbuf := SQLERRM in the exception blocks . What is assigned to variable g_errbuf here?

EXCEPTION WHEN OTHERS THEN g_errbuf := SQLERRM; g_retcode := 2; write_log('Y', to_char(SYSDATE, 'HH24:MI:SS') || ' - ' || 'Data Error happened ...
test-img

LittleBitDeveloper

sql

debugging

plsql

plsql-package

Votes: 0

Answers: 1

Latest Answer

No better place to start the official documentation. If the exception is thrown, SQLERRM will contain the error message. Example: set serveroutput on size 999999 DECLARE l_num NUMBER; BEGIN l_num ...
test-img

Koen Lostrie

i'm getting error while running plsql package working till package creation

create table employee( employee_id number(10) NOT NULL, employee_name varchar2(50), employee_sal number(10), employee_role varchar2(50), employee_age number(10), CONSTRAINT employee_pk PRIMARY KEY(emp...
test-img

Ravindra

oracle

plsql

plsql-package

Votes: 0

Answers: 3

Latest Answer

Remove semi-colon at the end of the hire procedure in package body: CREATE OR REPLACE PACKAGE BODY hr AS PROCEDURE hire (enum IN NUMBER, ename IN VARCHAR2, ...
test-img

Littlefoot

Posts

Questions

Blogs

Jobs