connection to oracle (or session

[wari93110]

hi
first thanks for your forum, and excuse my langage because I am french and I speak very bad english!, but I will try

in first time I work with sql developper but it could not allow me to debug some programme, so I chose to work with the PL sql Developer
but this one does not permit to me to connect on database that the connection proprities on sql developer are :

connection name : s1
user name : sb0020
passeword : ******

hostname : 55.47.48.209
port :1522
SID : csdata

and in the tnsnames file I have

csdata =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 55.47.48.209)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = csdata )
)
)
the PLsql developer tel me this error :
Could not resolve the connect identifier specified

My question is
can I connect on this DB with PLsql Devloper ?
how can I resolve this problem?

merci.

 

[Marco Kalter]

Can you start PL/SQL Developer without connecting, go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

This should allow us to see which databases are available.

 

[wari93110]

HI thanks for your reply message
ok, since my first post I could connect to one database (CSDVDMST) with tow session (or login the first is log1@csdvmst and 2nd is log2@csdvmst)
but
-1- when I'am connect in log1@csdvmst
and when I try to debug a package procedure the is an error message
"ORA-01036: illegal variable name/number " ...

-2- when I'am connect in log2@csdvmst
the button "start debugger" is disable

so how will I do to be able to debug this procedure !!!
thanks a lot

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Plug-Ins

Aliases
CSDVDATA
CSDVDMST
EXTPROC_CONNECTION_DATA
INST1_HTTP

Homes
OraClient10g_home2 (c:\oracle\product\10.2.0\client_2)

DLLs
c:\oracle\product\10.2.0\client_2\bin\oci.dll

TNS File
c:\oracle\product\10.2.0\client_2\Network\Admin\tnsnames.ora

Using
Home: OraClient10g_home2
DLL: c:\oracle\product\10.2.0\client_2\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Character size: 1 byte(s)

 

[Marco Kalter]

-1- when I'am connect in log1@csdvmst
and when I try to debug a package procedure the is an error message
"ORA-01036: illegal variable name/number " ...

This indicates that you have declared a variable in the bottom section of the Test Window that is not used in the PL/SQL Block of the Text Window with a :variable expression.

-2- when I'am connect in log2@csdvmst
the button "start debugger" is disable

Perhaps you are using Single Session mode? The debugger can only be used in Multi Session and Dual Session mode.

 

[wari93110]

ok thank you
I will see that.