thx for help, let me try it out.
thx.
daniel
LIVIU STOICA <[EMAIL PROTECTED]> wrote:
Hi,
An OciConnection establishes a database connection using Oci (Oracle Call Interface).
Within the context of an OciConnection, SQL statements are executed and results are returned
Example{ loginProperty LoginProperty = new LoginProperty();
ociConnection ociConnection;
statement stmt;
resultSet res;
;
LoginProperty.setServer("ORACLETESTSRV");
LoginProperty.setDatabase("AXDB");
LoginProperty.setUsername("TEST");
LoginProperty.setPassword("TEST_PWD");
try
{
ociConnection = new ociConnection(LoginProperty);
}
catch
{
print "Unable to establish connection with database";
return;
}
stmt = ociConnection.createStatement();
res = stmt.executeQuery("SELECT empName FROM emp");
while (res.next())
print res.getString(1);
pause;
}
Best regards,
Liviu
daniellim_yh <[EMAIL PROTECTED]> wrote:
hi there,
anyone have idea how to call an oracle 9's stored procedure? from
connection setup until the calling syntax?thx in advance.
daniel
SPONSORED LINKS
Computer part Programming languages Microsoft axapta Support exchange
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "development-axapta" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
Yahoo! Mail
Bring photos to life! New PhotoMail makes sharing a breeze.
[Non-text portions of this message have been removed]
SPONSORED LINKS
Computer part Programming languages Microsoft axapta Support exchange
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "development-axapta" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
Yahoo! Mail
Use Photomail to share photos without annoying attachments.
[Non-text portions of this message have been removed]
SPONSORED LINKS
| Computer part | Programming languages | Microsoft axapta |
| Support exchange |
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
