Posts

Showing posts with the label PL/SQL error handling

Featured Post

Step-by-Step Guide to Creating an AWS RDS Database Instance

-
Image
 Amazon Relational Database Service (AWS RDS) makes it easy to set up, operate, and scale a relational database in the cloud. Instead of managing servers, patching OS, and handling backups manually, AWS RDS takes care of the heavy lifting so you can focus on building applications and data pipelines. In this blog, we’ll walk through how to create an AWS RDS instance , key configuration choices, and best practices you should follow in real-world projects. What is AWS RDS? AWS RDS is a managed database service that supports popular relational engines such as: Amazon Aurora (MySQL / PostgreSQL compatible) MySQL PostgreSQL MariaDB Oracle SQL Server With RDS, AWS manages: Database provisioning Automated backups Software patching High availability (Multi-AZ) Monitoring and scaling Prerequisites Before creating an RDS instance, make sure you have: An active AWS account Proper IAM permissions (RDS, EC2, VPC) A basic understanding of: ...
Post a Comment
Read more

PL/SQL Sample code and error handling mechanism

-
SAMPLE PL/SQL CREATE TABLE dummy ( dummy_value VARCHAR2(1)); DECLARE -- Define local variable. my_string VARCHAR2(1) := ' '; my_number NUMBER; BEGIN -- Select a white space into a local variable. SELECT ' ' INTO my_string FROM dummy; -- Attempt to assign a single white space to a number. my_number := TO_NUMBER(my_string); EXCEPTION WHEN no_data_found THEN dbms_output.put_line('SELECT-INTO'||CHR(10)||SQLERRM); END; / Output and Error: The program returns the following output, which illustrates formatting user- defined exceptions.  The CHR(10) inserts a line return and provides a clean break between the program's SQLCODE and SQLERRM messages: RAISE my_error SQLCODE [1]  SQLERRM [User-Defined Exception]
Post a Comment
Read more