SET SERVEROUPUT ON

How to Resolve SP2-0547: size option out of range

by Ed Chen
May 27, 2022September 26, 2022

SP2-0547 Saw error SP2-0547 when we tried to set the buffer size of server output in SQL*Plus. SQL> set serveroutput on size 1000; SP2-0547: size… Read More »

SQL Bind Variables, How and Why

by Ed Chen
January 24, 2019December 10, 2022

Bind Variables Shareable Cursor Using bind variables can make statements with minor differences become literally the same so as to share the same cursor when… Read More »