System Profile
...
| Database Platform and Version | Oracle 12c |
|---|---|
| Development Language and Framework | ASP .NET Framework 4.7.2 VB .NET Framework 4.7.2 |
| Operating System and Version | Windows Server 2016 |
...
Problem:
Would you know why we can’t access SSB database, getting the following error message: "ORA-28000: the account is locked"? Does it reside now on a different server, we’re connecting to the one indicated in the attached RDIMS document?
Solution:
TFS 14057
Request to insert bulletins into the SSB database
Problem:
The user has request that new bulletin information be added to the SSB database.
Solution:
Bug 34317, has details using the following SQL script:
| Code Block | ||
|---|---|---|
| ||
--Transaction Log: 18 June 2020 @ 0725
--insert into ssb.bm001_bulletin Rows affected: 1
--SQL:
DECLARE
str_v_bulletin_cd VARCHAR2(10) := '16/2020';
str_v_bulletin_title_enm VARCHAR2(255) := 'Hazards and Risks of Girding During Towing Operations'; -- update this value
str_v_bulletin_title_fnm VARCHAR2(255) := 'Dangers et risques liés à l`engagement pendant les opérations de remorquage'; -- update this value
str_v_replacement_bulletin_cd VARCHAR2(10) := null; -- update this value
dte_v_date DATE := TO_DATE('2020-06-05', 'yyyy-mm-dd'); -- update this value
num_v_archived_ind NUMBER(1) := 0; -- update this value
BEGIN
insert into ssb.bm001_bulletin
(bulletin_cd,
bulletin_title_enm,
bulletin_title_fnm,
replacement_bulletin_cd,
date_created_dte,
date_last_update_dte,
date_current_dte,
archived_ind)
values
(str_v_bulletin_cd,
str_v_bulletin_title_enm,
str_v_bulletin_title_fnm,
str_v_replacement_bulletin_cd,
dte_v_date,
dte_v_date,
dte_v_date,
num_v_archived_ind);
DBMS_OUTPUT.PUT_LINE('insert into ssb.bm001_bulletin Rows affected: ' ||
sql%rowcount); -- 1 row
--COMMIT;
END; |