Digital Automations

08/01/2025

NETWORK PROTOCOL ADAPTER ERROR
sounds like the database is not up. you probably restarted your machine and the instance is not set to autostart

C:\Documents and Settings\tkyte>sqlplus scott/tiger

SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:43:55 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production
With the Partitioning, OLAP and Data Mining options

scott%ORA10GR1> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production
With the Partitioning, OLAP and Data Mining options

C:\Documents and Settings\tkyte>net stop oracleserviceora10gr1
The OracleServiceORA10GR1 service is stopping.........
The OracleServiceORA10GR1 service was stopped successfully.


C:\Documents and Settings\tkyte>sqlplus scott/tiger

SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:44:35 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

C:\Documents and Settings\tkyte>net start oracleserviceora10gr1
The OracleServiceORA10GR1 service is starting..........
The OracleServiceORA10GR1 service was started successfully.


C:\Documents and Settings\tkyte>sqlplus scott/tiger

SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:45:12 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production
With the Partitioning, OLAP and Data Mining options

scott%ORA10GR1>

28/12/2024

INSERT INTO LOG_TRAIL VALUES (USER, SYSDATE,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'),
SYS_CONTEXT('userenv','IP_ADDRESS',20),SYS_CONTEXT('userenv','os_user',30),
SYS_CONTEXT('userenv','HOST',30), 'LOGON')
DESC LOG_TRAIL

17/09/2024

A pager, also known as a beeper or bleeper,[1] is a wireless telecommunications device that receives and displays alphanumeric or voice messages. One-way pagers can only receive messages, while response pagers and two-way pagers can also acknowledge, reply to, and originate messages using an internal transmitter.[2] In Japanese, it was commonly

27/04/2024

Change the user profile password validity period.
ALTER PROFILE MYPROFILE LIMIT PASSWORD_LIFE_TIME UNLIMITED;

26/04/2024

What is last Query run in Oracle Db....
SELECT program_id, program_line #, sql_text
FROM V$SQL VS , ALL_USERS AU
WHERE (executions >= 1)
AND (parsing_user_id != 0)
AND (AU.user_id(+) = VS.parsing_user_id)
AND UPPER(AU.USERNAME) IN (UPPER('AGC24'))
ORDER BY last_active_time DESC;

16/02/2024

🍽️✨ Do you dream of running your restaurant with high efficiency and ease? ✨🍽️

We offer you the perfect solution to manage every aspect of your restaurant from the warehouse to the finest details in the menu!

🔹 Manage the warehouse efficiently: no need to worry about inventory levels or sudden shortages of ingredients the day after. Our system allows you to monitor and manage inventory with high precision, ensuring a smooth workflow without any disruption.

🔹 Online table reservation: goodbye to paper reservations and frequent phone calls. With our system, your customers can easily book their tables online, providing you and them a seamless and convenient booking experience.

🔹 Complete menu control: Would you like to easily update your restaurant's menu? Our system gives you complete freedom to add, delete or modify any menu item anytime and anywhere, ensuring you have the ability to renew and update continuously to meet your customers' desires.

🌟 Make your restaurant shine with high efficiency and unmatched presentation. With our system, everything is under your control at the touch of a button. 🌟

💬 For more information and to start the transition towards optimal management of your restaurant, get in touch now! To see the whole system and 2 weeks free trial

03/02/2024

The following is the list of Oracle Form's keyboard shortcuts used in design time.

Oracle Forms Keyboard Shortcuts List
Key

Ctrl+NNew Form

Ctrl+O

Open Form

Ctrl+W

Close Form

Ctrl+S

Save Form

Shift+Ctrl+S

Save As

Ctrl+J

Connect

Ctrl+P

Print

F2

Opens The Layout Editor

F3

Return to The Object Navigator

F4

Displays The Property Palette

F11

Opens The PL/SQL Editor

Ctrl+Insert

Create an Object

Ctrl+K

Incremental Compile

Shift+Ctrl+K

Compile All

Ctrl+T

Compile Module (build fmx)

Ctrl+H

Help

31/01/2024

30/01/2024

capture image by camra

We will discuss how to easily make an image capture feature from camera with JavaScript and include examples.

30/01/2024

Html portion
Start Camera

Click Photo



let camera_button = document.querySelector(" -camera");
let video = document.querySelector(" ");
let click_button = document.querySelector(" -photo");
let canvas = document.querySelector(" ");

camera_button.addEventListener('click', async function() {
let stream = await navigator.mediaDevices.getUserMedia({ video: true, audio: false });
video.srcObject = stream;
});

click_button.addEventListener('click', function() {
canvas.getContext('2d').drawImage(video, 0, 0, canvas.width, canvas.height);
let image_data_url = canvas.toDataURL('image/jpeg');

// data url of the image
console.log(image_data_url);
});

30/01/2024

capure photo from Camra in Java script
let camera_button = document.querySelector(" -camera");
let video = document.querySelector(" ");
let click_button = document.querySelector(" -photo");
let canvas = document.querySelector(" ");

camera_button.addEventListener('click', async function() {
let stream = await navigator.mediaDevices.getUserMedia({ video: true, audio: false });
video.srcObject = stream;
});

click_button.addEventListener('click', function() {
canvas.getContext('2d').drawImage(video, 0, 0, canvas.width, canvas.height);
let image_data_url = canvas.toDataURL('image/jpeg');

// data url of the image
console.log(image_data_url);
});

27/12/2023

PL/SQL Procedure for Importing Data
CREATE OR REPLACE PROCEDURE p_import_EMP

IS

l_file_type UTL_FILE.file_type;

l_string VARCHAR2 (32765);

TYPE Fieldvalue IS TABLE OF VARCHAR2 (4000) INDEX BY BINARY_INTEGER;

t_field Fieldvalue;

FUNCTION GetString (Source_string IN VARCHAR2,
Field_position IN NUMBER,
UnTerminated IN BOOLEAN DEFAULT FALSE,
Delimiter IN VARCHAR2 DEFAULT ',')
RETURN VARCHAR2
IS
iPtrEnd PLS_INTEGER := 0;
iPtrStart PLS_INTEGER := 0;
vcSourceStrCopy VARCHAR2 (4000) := Source_string;
BEGIN
IF UnTerminated
THEN
vcSourceStrCopy := vcSourceStrCopy || Delimiter;
END IF;

IF Field_Position > 1
THEN
iPtrStart :=
INSTR (vcSourceStrCopy,
Delimiter,
1,

Field_Position - 1)
+ LENGTH (Delimiter);
ELSE
iPtrStart := 1;
END IF;

iPtrEnd :=
INSTR (vcSourceStrCopy,
Delimiter,
1,
Field_Position);
RETURN SUBSTR (vcSourceStrCopy, iPtrStart, (iPtrEnd - iPtrStart));
END GetString;

BEGIN

l_file_type := UTL_FILE.Fopen ('CSV_DIR', 'sample.csv', 'r');

For r in 1..1 Loop
UTL_FILE.Get_Line(l_file_type, l_string);

End Loop;

LOOP
UTL_FILE.Get_Line (l_file_type, l_string);

l_string := l_string || ',';

FOR n IN 1 .. 5
LOOP
t_field (n) :=
Getstring (l_string,
n,
FALSE,
',');
END LOOP;

INSERT INTO EMP (
EMPNO,
ENAME,
JOB,
MGR,
HIREDATE
)
VALUES (
t_field(1),
t_field(2),
t_field(3),
t_field(4),
t_field(5)
);

END LOOP;

EXCEPTION
WHEN OTHERS
THEN
IF UTL_FILE.is_open (l_file_type)
THEN
COMMIT;
UTL_FILE.Fclose (l_file_type);
END IF;
END;