I am encountering error when I try to run following procedure--
CREATE OR REPLACE PROCEDURE REMOVEINDEX
EXECUTE IMMEDIATE 'alter table T1 drop constraint PK_T1';
raise_application_error(-20024,'fail at PK_T1');
EXECUTE IMMEDIATE 'alter table T2 drop constraint PK_T2';
raise_application_error(-20025,'fail at PK_T2');
Error is as follows--
7/1 PLS-00103: Encountered the symbol "RAISE_APPLICATION_ERROR" when
expecting one of the following:
The symbol "pragma" was substituted for "RAISE_APPLICATION_ERROR"
8/1 PLS-00103: Encountered the symbol "END" when expecting one of the
15/1 PLS-00103: Encountered the symbol "RAISE_APPLICATION_ERROR" when
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
This way, I guessed, I would ensure that use…
PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.