Loop - Two Variables (username / Password) Not Clearing Out?

Apr 15, 2008

The idea of the program below is to create a sql "module" (just a .sql file) that will loop and ask for a user id until the user enters the correct one. Here is the code I have thusfar:

set serveroutput on;
accept username prompt 'Enter user name here: ';
accept password prompt 'Enter password here: ';

declare
usernameCONFIRM VARCHAR(30);
passwordCONFIRM VARCHAR(30);
begin
select USERID into usernameCONFIRM from GAMEUSER where USERID = '&username';

[code]...

The main problem I'm seeing is that the two variables I ask for (username and password) aren't clearing out.

View 12 Replies


ADVERTISEMENT

Oracle 9i Default Username And Password

Sep 14, 2003

I Just got Oracle 9i installed. But can not login . What are the Default username and password for "Oracle9i Discoverer Administrator" and other Developers Suite apps?

Also What URL should i type to access the "iSQL *PLUS" through my browser, so that i can execute my SQL statements.

View 3 Replies View Related

Forms :: Hide Username And Password?

Mar 21, 2011

I already did the hide of username and password, now i need to recieve in cgicmd.dat a parameter because i already have the way of reports i want only to recieve the name of them, so i put like this:

sct: userid="user/pass@database" destype=cache desformat=pdf report=c:\%1

So when i run this show me the message:

File 'c: este.rdf=%' not found.

It's showing a '=' sign

View 1 Replies View Related

Server Utilities :: Username And Password In Exp / Imp?

Apr 26, 2011

While doing export/import we specify the username and password. Preferably which user do we need to specify? Sys or system or our own user?

View 9 Replies View Related

SQL & PL/SQL :: Variables In Loop Procedure

Feb 15, 2010

PROCEDURE CALCULATE_CASH_REBAL( P_Account_id IN VARCHAR2,
P_Txn_Ccy IN VARCHAR2,
P_Allocation IN VARCHAR2,
l_lty_id IN VARCHAR2 ) IS
l_balance_fmt NUMBER := 0;
BEGIN
[code]....

it should be updating l_balance_fmt field for all the records in the loop. my question is when it loops to the next cash txn record, will it take the previous value of l_balance_fmt ? it should start again and take 0 as the balance_fmt and add to that..

View 3 Replies View Related

Application Express :: XDB Requires Username And Password

Jun 1, 2013

11.2.0.1.0 g database.

I am trying for testing on test server where I am getting error while trying to connect

[URL].....

I am able to connect

[URL]........

and

[URL]......

The database version is 11g.

Actually my requirement is As I know we cannot use isqlplus in 11g we can use apex instead of isqlplus so any way or navigation how to use apex for isqlplus.

View 1 Replies View Related

Reports & Discoverer :: To Hide The Username And Password

Dec 20, 2010

I migrated the report from Developer 2000. This report has the drill down report with the following command.

procedure U_1ButtonAction is
begin
srw.run_report('rep022.rep paramform=no
p11="'||:cr_call_ref_no||'"');
end;

After Migration into Oracle Application Server 10g release 2 , I changed the code as following:

function U_1FormatTrigger return boolean is
begin

SRW.SET_HYPERLINK(' http://cpstest.exch1.mas.unb.com:7778/reports/rwservlet?report=E:CallSystem
ep022.rdf&USERID=dss/dss@dsdb&destype=cache& ;desformat=pdf&p11="'||:cr_call_ref_no||'"');
return (TRUE);
end;
-----------
Problem

When I run the report, it shows the toolbar on the link [with the user id & password] of the drilldown report.

I wish to hide the username & password or I wish to enter my message "Click the link to open the Report".

View 5 Replies View Related

XE :: Error ORA-01017 Invalid Username / Password

Feb 15, 2013

I just finish to install Oracle XE on Fedora 18 so when I try to Start SQL, I get this error.

[root@fedora ~]# sqlplus system

SQL*Plus: Release 11.2.0.2.0 Production on Fri Feb 15 02:18:14 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.

Enter password: ERROR: ORA-01017: invalid username/password; logon denied.

View 2 Replies View Related

PL/SQL Loop Types - Variables Incrementing Together

Nov 8, 2012

set server output on;

DECLARE
num number(1) :=1;
num2 number(1) := 1;
BEGIN
WHILE num < 5 LOOP
[code]...........

the output for this loop is:
1+1=2
2+2=4
3+3=6
4+4=8

this is what I wanted. Both variables are incrementing together. However, when I try to use a FOR loop to do the same thing:

set serveroutput on;

DECLARE
num number(1) :=1;
num2 number(1) := 1;
BEGIN
FOR i in 1..4 LOOP
[code].......

I get the result:

1+1=2
1+2=3
1+3=4
1+4=5
2+5=7
2+6=8
2+7=9
2+8=10
3+9=12
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: number precision too large
ORA-06512: at line 8

I understand the output means the inner loop is running its course before the outer loop is started and then continuing on to exceed its limit, but I don't understand why this is or how to make it so I get the same results as the WHILE loops.

View 4 Replies View Related

SQL & PL/SQL :: How To Give Username And Password When Calling HTTP Page

Apr 16, 2013

I have this code when i run this I get credentials error. How to give credentials .The authentication is set to windows in the https page. Means pop up will appear to get the credentials

declare
req UTL_HTTP.REQ;
resp UTL_HTTP.RESP;
value varchar2(1024);
p_url varchar2(4000);
OPT varchar2(1000);
BEGIN
dbms_output.put_line('');

[code]....

View 1 Replies View Related

SQL & PL/SQL :: Oracle - Create Procedure To Check Username And Password?

Aug 23, 2011

how can i create procedure to check username and password.

View 10 Replies View Related

Server Administration :: Can't Login By Typing Username And Password

Jul 15, 2010

I am using oracle 9i version. My problem is oracle window opens.But i can not login by typing the user name and password. while login an error is displayed as follows.

ORA-01033: ORACLE initialization or shutdown in progress.

View 8 Replies View Related

Forms :: Invalid Username / Password - Login Denied

Aug 9, 2011

I have installed oracle 10g database in my pc and it works fine. I can connect with sys or system user.

I have also installed oracle forms 10g in the same pc. But when I try to connect then it shows the message:

ORA-01017 invalid username/password; login denied

So I can not connect. I have tried to connect with sys or system user.

View 6 Replies View Related

ORA-01017 - Invalid Username / Password - Logon Denied

Jun 26, 2012

Case 1,

-I have a Oracle Client 11.2.0.1 (*Administrator*) installed on a client machine on Redhat 6.
-I have a database 11.2.0.1 testdb installed on another machine.

I configured tnsnames.ora for the client machine to connect my database testdb.If I use sqlplus to connect to the testdb from client machine, it's successful.However, If I use one of the jdbc connection string from the client machine, it reports "ORA-01017: invalid username/password; logon denied"

Case 2,

-I have a Oracle Client 11.2.0.1 (*Runtime*) installed on a client machine on Redhat 6.
-I have a database 11.2.0.1 testdb installed on another machine.

I configured tnsnames.ora for the client machine to connect my database testdb.

-If I use sqlplus to connect to the testdb from client machine, it's successful.
-If I use one of the jdbc connection string from the client machine, it 's successful too.

For case 1 and case 2, the only difference is the Oracle client (one is Runtime, the other is administrator)The database I have is set to

SQL> show parameters case

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean FALSE

why the administrator client report ORA-01017?

View 15 Replies View Related

SQL & PL/SQL :: Creating Loop - Sequence Should Add A Number In The End Of Variables

Jun 12, 2013

SELECT
DECODE(BREINV1.NAMEKEY, NULL,'0','1') "BRE_INV1",
DECODE(BREINV1.NAMEKEY, NULL,' ',BREINV1.SEQUENCE) "BRE_NUMINV1",
DECODE(BREINV1.NAMEKEY, NULL, ' ', DECODE(BREINV1.SEQUENCE,NULL,NULL,

[Code]....

My problem, I have the query which works correctly. However as you can see there is always a sequence number in the end of variables and I am not sure the total number of cases, so I have to create a loop for the same query.

I am doing the same things on BREINV1 BREINV2 BREINV3 BREINV4... AND BRENUMINV1 BRENUMINV2... so the sequence should add a number in the end of variables...

View 39 Replies View Related

Reports & Discoverer :: How To Hide Username And Password In Web Show Document

Jul 1, 2013

I want to hide the URL or Username and password in web.show_document. While accessing report through form any end user can see the url. I need to hide the credentials.

View 6 Replies View Related

Security :: ORA-01017 / Invalid Username / Password - Logon Denied

Jul 2, 2011

I am not able to login in the database with sys user. when i am trying with sqlplus "/as sysdba" it is showing

ERROR: ORA-01031: insufficient privileges.

& when i am trying with sqlplus sys as sysdba it is showing

ERROR:ORA-01017: invalid username/password; logon denied.

I login with system user and changed the password of sys nd then tried login with sys but same result.

remote_login_passwordfile is set to NONE nd i am login through that user only by which i was always able to login.

View 23 Replies View Related

Security :: ORA-01017 - Invalid Username / Password - Logon Denied?

Sep 24, 2013

I have a log-in problem. I created the new database and when I try to log-in with system user, its giving ORA-01017: invalid username/password; log-in denied, and when I try to log-in with "/ as sysdba" its successfully logged in.

When I try to change SYSTEM user password, I successful change and connecting and after few seconds when I try to connect its again giving same error "ORA-01017: invalid username/password; log-in denied

And I disable the case sensitive password also:

sec_case_sensitive_logon boolean FALSE

OS: windows
Oracle Versions: 11.2.0.1.0

View 6 Replies View Related

Data Guard :: ORA-17627 / ORA-01017 Invalid Username / Password

Aug 21, 2013

I have a strange behavior with a Data Guard environment on Linux and Oracle 11.2.0.2. Since a couple of days, I have the following error in the alertlog of the standby database: 

Errors in file /u00/app/oracle/diag/rdbms/SID_site2/SID/trace/SID_pr0f_22728.trc:ORA-17627: ORA-01017:
invalid username/password; logon deniedORA-17629: Cannot connect to the remote database server First I restarted the Apply on the standby without any changes.

So I tried to connect to the primary database from the standby server with Oracle .Net with success. In the other way, it's also working.I also tried to copy the password file from the primary server to the standby server and I restarted both the transport and the apply.The error is still happening on the standby but the most surprising is that the Data Guard is still fully synchronized. Why I get that error and what is the function of the process pr0f?

View 13 Replies View Related

Server Administration :: Role Cannot Login - Invalid Username / Password

Oct 9, 2011

I created a role,and it can not login,why?

session1:

SQL> Create Role con_role Identified By hxl;

Role created.

SQL> Grant Connect To con_role;

Grant succeeded.

SQL> Grant Create Session To con_role;

Grant succeeded.

session2:

sql>connect con_role/hxl@myserver ORA-01017: Invalid username/password.

View 12 Replies View Related

Client Tools :: Not Able To Launch Sql Prompt After Entering Username And Password?

Oct 17, 2011

I have installed Oracle 10 galso changed the password of Scott,System users during installation via passwordmanagement. When I am click on sql plus icon to launch sql and entering user name : Scoot pwd :Tiger

It get closed and nothing is coming up.

View 7 Replies View Related

Reports & Discoverer :: Hiding Username / Password When Calling From Hyperlink HTML?

Jun 30, 2010

Can we hide the username/password@dbname from hyperlink html, so that when ever we change our user password we should not change in each report calling from another report

View 1 Replies View Related

Enterprise Manager :: Invalid Username And / Or Password Cluster Credentials Startup OEM

Apr 12, 2012

I have an installation Oracle 11.2 RAC on Oracle Linux 5.5 on VirtualBox 3.2.8, Enterprise Manager Startup Log In does not recognize the SYSMAN username / password.

Log's (I changed // for /):

[oracle@rac1 log]$ tail -10 emagent.trc
2012-04-12 14:31:08,327 Thread-1148807488 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https:/rac1.localdomain:1158/em/upload/: retStatus=-1
2012-04-12 14:32:09,333 Thread-1148807488 WARN ssl: <nmehlssl.c:nmehlssl_readcb>: nmehl_read_sock timed out, rsf = -5, setting read timeout flag
2012-04-12 14:32:09,335 Thread-1148807488 ERROR ssl: nzos_Handshake failed, ret=28862
2012-04-12 14:32:09,336 Thread-1148807488 ERROR http: 6: Unable to initialize ssl connection with server, aborting connection attempt
2012-04-12 14:32:09,338 Thread-1148807488 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https:/rac1.localdomain:1158/em/upload/: retStatus=-1
2012-04-12 14:32:39,777 Thread-1148807488 WARN ssl: <nmehlssl.c:nmehlssl_readcb>: nmehl_read_sock timed out, rsf = -5, setting read timeout flag

[code]...

View 2 Replies View Related

Server Administration :: ORA-01017 / Invalid Username / Password / Logon Denied

Jan 26, 2012

ORA-00600: internal error code, arguments: [kcbchg1_11], [], [], [], [], [], [], []
ORA-01017: invalid username/password; logon denied
Current SQL statement for this session:
insert into sys.aud$( sessionid,entryid,statement,timestamp#, userid,userhost,terminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, new$owner,
new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,comment$text,spare1,spare2, priv$used,clientid, sessioncpu) values(:1,:2,:3,SYSDATE,:4,:5,:6,:7,:8
,:9, :10,:11,:12,:13,:14,:15,:16,:17, :18,:19,:20,:21,:22,:23,:24, :25)

View 6 Replies View Related

ORA-01017 / Invalid Username / Password Logon Denied But SQLPLUS Works

Oct 15, 2012

"ORA-01017: invalid username/password; logon denied" when attempting to log on to db, in three different applications. Error is observed in Toad, Crystal Reports, and MS ODBC Administrator connect test. However, same db credentials work in SQLPLUS.

Customer is attempting to log into reporting database hosted by my company, and using Cisco VPN client.I am unable to reproduce this at this time, on my machine, using same credentials and VPN profile.

Here is what we know/tried:
 
1. PING HOSTNAME is successful on CUSTOMER’S machine

2. TNSPING HOSTNAME is successful on CUSTOMER’S machine

3. SQLPLUS is successful with USER2/(pw)@HOSTNAME.int on CUSTOMER’S machine

4. We corrected timeout error on CUSTOMER’S side, by adding TCP.CONNECT_TIMEOUT=1000 in SQLNET.ORA (Also observed extremely slow performance on CUSTOMER SIDE)

5. We corrected dns suffix problem on CUSTOMER’S side, observed in NSLOOKUP by adding: IP ADDRESS AND HOSTNAME to Windows HOSTS file and commenting out default suffix COMPANY.com from SQLNET.ORA file

6. VPN configuration and VPN credentials are good. 

We tested CUSTOMER’S VPN profle, CUSTOMER’S VPN credentials, and user USER2/(pw)@HOSTNAME on my machine (WIN7). I am able to maintain persistant connection to HOSTNAME for hours

7. TNSNames entries are good. Able to connect to db in Toad, and Crystal, on CUSTOMER’S machine using different Oracle user, USER3 (only has grant connect). Unable to logon to db, with Oracle user USER1, or USER2. (USER2 was created to try to resolve login problem w USER1, but issue still exists.)

8. CUSTOMER has Windows VISTA, does not have admin privileges, has Oracle 10 installed for client. Using same Cisco VPN client I have installed.

9. Database on our servers is 11g

View 11 Replies View Related

Application Express :: Login First Time Asked About Server XDB Username And Password

Aug 27, 2012

when i try to login to apex for first time (10.10.0.170:5555) it asked about server XDB username and password,i dont know which username and password i can use

View 4 Replies View Related

Client Tools :: Export Toad Saved Username Password And Import On Sqldevloper?

Jul 1, 2013

I want to use the saved Toad username password into SqlDeveloper. is there any way to use the same username password without recreating new connection to users.

View 3 Replies View Related

Pass Variables For UserID And Password To Sqlplus In Windows From Text File?

Jul 23, 2013

I would like to store user-id, password and the TNS-Entry in a small text file and pass them to a script to log in and execute another script on the database from Windows.

Example of the text file samp.txt that stores user info:

username=Jdoe
password=candybar
db_sid:orcl

main script main.bat is as follows:

--read the samp.txt do not know how to do it

sqlplus -s &username/&password@&db_sid @db_info.sql

db_info.sql contents:

column tm new_value file_time noprint
select to_char(sysdate, 'YYYYMMDD') tm from dual ;
spool C:\server\DB_Report_&file_time..log
select * from v$instance;
spool off;
exit

View 1 Replies View Related

Forms :: Creating A Username And Password In Oracle Forms 6i

Sep 12, 2010

I created a form to create a username and password.i tried creating a user in forms 6i using the following code on the when button pressed trigger:

BEGIN
forms_ddl('create user'||:user_name||'identified by'||:pasword);
commit_form;
END;

i have granted the user to create user but it does not work at all. password and user_name are captured in the form.

View 7 Replies View Related

Difference Between #username And ?username In SPARE1 Column?

Oct 31, 2010

whats the different between a #username and ?username in a SPARE1 column?

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved