This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
set echo on | |
set pages600 | |
set linesize 132 | |
spool create_proc_autonomous_comment_ddl | |
create or replace procedure proc_autonomous_comment_ddl | |
(in_table_name in varchar , in_comment_28char in varchar) | |
is | |
pragma autonomous_transaction; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#include <errno.h> | |
#include <fcntl.h> | |
#include <stdio.h> | |
#include <stdlib.h> | |
#include <string.h> | |
#include <sys/stat.h> | |
#include <sys/syscall.h> | |
#include <sys/types.h> | |
#include <unistd.h> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- see https://hemantoracledba.blogspot.com/2021/04/using-sessionlongops-view-with.html for a demo | |
DECLARE | |
rindex BINARY_INTEGER; | |
slno BINARY_INTEGER; | |
target_count number; | |
updated_count number; | |
product_row products%rowtype; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- see demo at https://hemantoracledba.blogspot.com/2021/04/ojvm-loading-java-code-and-running-it.html | |
-- grant Java Code permission to only READ only /home/oracle/tmp | |
-- this should have been provided by the DBA | |
begin | |
dbms_java.grant_permission('HEMANT', | |
'SYS:java.io.FilePermission', | |
'/home/oracle/tmp', 'read'); | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
############ | |
This part is the shell scrip to compile the Pro*C source "instancedbinfo.pc" into "instancedbinfo.c and then into an executable | |
echo "*****Set LD_LIBRARY_PATH" | |
LD_LIBRARY_PATH=/usr/lib/gcc/x86_64-redhat-linux/4.8.2/include:/usr/include/linux:/opt/oracle/product/19c/dbhome_1/precom/lib:/opt/oracle/product/19c/dbhome_1/lib | |
export LD_LIBRARY_PATH | |
echo "*****Set C_INCLUDE_PATH" | |
C_INCLUDE_PATH=/usr/lib/gcc/x86_64-redhat-linux/4.8.2/include:/usr/include/linux:/opt/oracle/product/19c/dbhome_1/precom/lib:/opt/oracle/product/19c/dbhome_1/lib:/opt/oracle/product/19c/dbhome_1/precomp/public |
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.