1SELECT NAME, ADDRESS, PHONE
2INTO v_employee_name, v_employee_address, v_employee_phone_number
3FROM EMPLOYEE
4WHERE EMPLOYYE_ID = 6;
1 SELECT * INTO nome_da_tabela_que_estao_a_mexer_BKP
2 FROM nome_da_tabela_que_estao_a_mexer
1Wed, 17 Mar 2021 15:19:22 GMT
2
3Failed to execute target procedure ORA-06502: PL/SQL: numeric or value error: character string buffer too small
4ORA-06512: at "CMFIN_09.CMA_FICHA_MANTER", line 790
5ORA-06512: at line 33
6
7 DAD name: cmfin_09
8 PROCEDURE : CMA_FICHA_MANTER.inserir_trata
9 URL : http://rai-dc-appdev.gov.cv:80/cmfin_09/CMA_FICHA_MANTER.inserir_trata
10 PARAMETERS :
11 ===========
12 sessid:
13 20081725210350882001
14 p_id:
15 67828
16 qual_utente:
17 0
18 p_marca:
19 VOLKSWAGEN
20 p_especie:
21 AUTOMÓVEL
22 p_cilindrada:
23 3500
24 p_matricula:
25 st-00-ZL
26 p_dt_matricula:
27 23-02-2021
28 p_registo:
29 232
30 p_memo:
31
32 p_activo:
33 on
34 P_ANO_ISENCAO_JUROS:
35 NULL
36 p_utente_id:
37 97610
38
39
40
41
42 p_utente:
43 Aderito Filipe Pina Goncalves
44
45
46
47
48 btnConfirmar:
49 32
50 12
51
52 ENVIRONMENT:
53 ============
54 PLSQL_GATEWAY=WebDb
55 GATEWAY_IVERSION=2
56 SERVER_SOFTWARE=Oracle-HTTP-Server-11g
57 GATEWAY_INTERFACE=CGI/1.1
58 SERVER_PORT=80
59 SERVER_NAME=rai-dc-appdev.gov.cv
60 REQUEST_METHOD=POST
61 QUERY_STRING=
62 PATH_INFO=/CMA_FICHA_MANTER.inserir_trata
63 SCRIPT_NAME=/cmfin_09
64 REMOTE_HOST=
65 REMOTE_ADDR=10.0.28.8
66 SERVER_PROTOCOL=HTTP/1.1
67 REQUEST_PROTOCOL=HTTP
68 REMOTE_USER=cmfin_09
69 ORACLE_SSO_USER=
70 OSSO_IDLE_TIMEOUT_EXCEEDED=
71 OSSO_USER_GUID=
72 HTTP_CONTENT_LENGTH=402
73 HTTP_CONTENT_TYPE=application/x-www-form-urlencoded
74 HTTP_USER_AGENT=Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36
75 HTTP_HOST=nosiappsdev.gov.cv
76 HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9
77 HTTP_ACCEPT_ENCODING=gzip, deflate, br
78 HTTP_ACCEPT_LANGUAGE=pt-PT,pt;q=0.9,en-US;q=0.8,en;q=0.7
79 HTTP_ACCEPT_CHARSET=
80 HTTP_COOKIE=acgroupswithpersist=nada; nosimail=9FEEF8C6ECD9855F2C41AF7EF44E7F46E74C36F0; iNavigate_=1; iNavigate__35=0; acopendivids=Q4; nosiactiv=ADERITO.GONCALVES; iNavigate__11=0; iNavigate__16=0; iNavigate__57=0; iNavigate__18=0; iNavigate__58=0; iNavigate__34=0; iNavigate__12=0; iNavigate__62=0; iNavigate__39=0; iNavigate__50=0; iNavigate__36=0; iNavigate__40=0; iNavigate__31=0; iNavigate__17=0; iNavigate__48=0; iNavigate__9=0; iNavigate__10=0; iNavigate__21=0; iNavigate__13=0; iNavigate__15=0; iNavigate__6=0; iNavigate__8=0; iNavigate__5=0; iNavigate__1=0; iNavigate__2=0; iNavigate__4=0; iNavigate__51=0; iNavigate__7=0; iNavigate__59=1; iNavigate__3=1; nosisso=BDBD7948A39B8E33E0530100007FE03E
81 HTTP_IF_MODIFIED_SINCE=
82 HTTP_REFERER=https://nosiappsdev.gov.cv/cmfin_09/CMA_FICHA_MANTER.show?sessid=20081725210350882001
83 HTTP_SOAPACTION=
84 HTTP_ORACLE_ECID=
85 HTTP_ORACLE_CACHE_VERSION=
86 HTTP_AUTHORIZATION=
87 WEB_AUTHENT_PREFIX=
88 DAD_NAME=cmfin_09
89 DOC_ACCESS_PATH=docs
90 DOCUMENT_TABLE=rh_funcionarios_upload
91 PATH_ALIAS=
92 REQUEST_CHARSET=WE8MSWIN1252
93 REQUEST_IANA_CHARSET=WINDOWS-1252
94 SCRIPT_PREFIX=
95 HTTP_IF_MATCH=
96 HTTP_CACHE_CONTROL=
97 SOAP_BODY=
98 HTTP_X_ORACLE_DEVICE_CLASS=
99 HTTP_X_ORACLE_DEVICE_ORIENTATION=
100 HTTP_X_ORACLE_DEVICE_MAXDOCSIZE=
101 HTTP_X_ORACLE_DEVICE=
102 HTTP_X_ORACLE_ORIG_ACCEPT=
103 HTTP_X_ORACLE_ORIG_USER_AGENT=
104 HTTP_X_ORACLE_USER_LOCALE=
105 HTTP_X_ORACLE_USER_NAME=
106 HTTP_X_ORACLE_USER_DISPLAYNAME=
107 HTTP_X_ORACLE_USER_USERKIND=
108 HTTP_X_ORACLE_USER_AUTHKIND=
109 HTTP_X_ORACLE_USER_DEVICEID=
110 HTTP_X_ORACLE_USER_LOCATION_ADDRESSLINE1=
111 HTTP_X_ORACLE_USER_LOCATION_ADDRESSLINE2=
112 HTTP_X_ORACLE_USER_LOCATION_ADDRESSLASTLINE=
113 HTTP_X_ORACLE_USER_LOCATION_BLOCK=
114 HTTP_X_ORACLE_USER_LOCATION_CITY=
115 HTTP_X_ORACLE_USER_LOCATION_COMPANYNAME=
116 HTTP_X_ORACLE_USER_LOCATION_COUNTY=
117 HTTP_X_ORACLE_USER_LOCATION_STATE=
118 HTTP_X_ORACLE_USER_LOCATION_POSTALCODE=
119 HTTP_X_ORACLE_USER_LOCATION_POSTALCODEEXT=
120 HTTP_X_ORACLE_USER_LOCATION_COUNTRY=
121 HTTP_X_ORACLE_USER_LOCATION_TYPE=
122 HTTP_X_ORACLE_USER_LOCATION_X=
123 HTTP_X_ORACLE_USER_LOCATION_Y=
124 HTTP_X_ORACLE_SERVICE_HOME_URL=
125 HTTP_X_ORACLE_SERVICE_PARENT_URL=
126 HTTP_X_ORACLE_HOME_URL=
127 HTTP_X_ORACLE_MODULE_CALLBACK_URL=
128 HTTP_X_ORACLE_MODULE_CALLBACK_LABEL=
129 HTTP_X_ORACLE_CACHE_USER=
130 HTTP_X_ORACLE_CACHE_SUBID=
131 HTTP_X_ORACLE_CACHE_AUTH=
132 HTTP_X_ORACLE_CACHE_DEVICE=
133 HTTP_X_ORACLE_CACHE_LANG=
134 HTTP_X_ORACLE_CACHE_ENCRYPT=
135 HTTP_X_ORACLE_ASSERT_USER=
136