Search found 77 matches

Go to advanced search

by hannes_a
Thu 08 Nov 2012 09:24
Forum: dotConnect for Oracle
Topic: ASP.NET OracleDataSource PIPELINED function
Replies: 1
Views: 884

ASP.NET OracleDataSource PIPELINED function

Hello,
I use on ASP.NET a OracleDataSource 5.70.190 in direct mode with this select

Code: Select all

select * from table(packname.functname(:id))
during designtime I can select data, but during runtime I get:
Error occured while parsing the FORM clause: identifier or expression expected
What can I do for workaround ?

By the way:

Code: Select all

with x as (select * form y)
select * from x
doesn't work, but there I found some workarounds

Thank you
by hannes_a
Sat 20 Aug 2011 13:22
Forum: dotConnect for Oracle
Topic: OracleDatasource produce a lot of select count(*)
Replies: 1
Views: 901

OracleDatasource produce a lot of select count(*)

OracleDatasource produce a lot of
select count(*) (select * from xyz /*my ordinary query*/)
for understanding: which part needs the affected rows ?
when I don't need it, can I stop this ?
by hannes_a
Sat 20 Aug 2011 12:34
Forum: dotConnect for Oracle
Topic: ORA-01036 and DBMonitor
Replies: 4
Views: 1034

as result, a hint about concerning parameter in message text would be perfect

thank you
by hannes_a
Fri 12 Aug 2011 09:35
Forum: dotConnect for Oracle
Topic: ORA-01036 and DBMonitor
Replies: 4
Views: 1034

ORA-01036 and DBMonitor

Hello,
I run into an ORA-01036, but DBMonitor doesn't show me this event,
can I see this event ?
if yes: where ?
if no: a suggestion for a new release

without showing where and why it's need a lot of time to solve this issue

thank you
by hannes_a
Tue 02 Aug 2011 08:02
Forum: Oracle Data Access Components
Topic: Installation Lazarus 0.9.30 win64 with ODAC 7.20 trial
Replies: 3
Views: 1825

:shock:
your suggested destination directory already exist but I miss your source directory.
ok, I try switch between source and destination directory, but same behavior

I hope you next version will work on win64 and linux64 as well
by hannes_a
Sat 30 Jul 2011 13:16
Forum: Oracle Data Access Components
Topic: Installation Lazarus 0.9.30 win64 with ODAC 7.20 trial
Replies: 3
Views: 1825

Installation Lazarus 0.9.30 win64 with ODAC 7.20 trial

for evaluation purpose I followed install instruction %ODAC%\doc\ODAC.pdf site 29

1: download ODAC 7.20 trial
2: copy ODAC dir to C:\Program Files\lazarus
2.1 there is no %ODAC%\Source\Lazarus1\dclodac.lpk :shock:
2.2.1 I open %ODAC%\packages\dclodac10.lpk instead
3. push 'Install'
4. translated message
Package dclodac10.lpk was marked for installation.
recent Lazarus only supports static linked packages.
Real installation needs compile and restart of Lazarus

Do you want Lazarus recompile ?
4.1 No -> nothing installed
4.2 Yes -> can't find CRAccess used by dac10
2.2.2 I open %ODAC%\packages\dcldac10.lpk instead
-> see 3 and 4

what did I wrong :?:
by hannes_a
Fri 19 Nov 2010 14:42
Forum: dotConnect for Oracle
Topic: ORA-01461 during update of CLOB in ASP
Replies: 13
Views: 122345

are there any news ?
I found nothing about this in the 5.70.190 changelog
by hannes_a
Mon 25 Oct 2010 07:33
Forum: dotConnect for Oracle
Topic: ORA-01461 during update of CLOB in ASP
Replies: 13
Views: 122345

I figured out with Version 5.70.180 and direct connection
  • on Linux 64 with Oracle 11.2: no problem
    on Win7 64 with Oracle 11.1: problem exist
OCI usage does not suit my needs
by hannes_a
Thu 21 Oct 2010 08:16
Forum: dotConnect for Oracle
Topic: ORA-01461 during update of CLOB in ASP
Replies: 13
Views: 122345

I sent you DDL scripts by email
by hannes_a
Mon 18 Oct 2010 12:20
Forum: dotConnect for Oracle
Topic: ORA-01461 during update of CLOB in ASP
Replies: 13
Views: 122345

I sent you a mail on 14.10.2010
My server is online since 14.10 till a solution is provided
by hannes_a
Tue 12 Oct 2010 09:18
Forum: dotConnect for Oracle
Topic: ORA-01461 during update of CLOB in ASP
Replies: 13
Views: 122345

1: you can use the connect string in my example, the db in online over internet
2: try edit/update in grid (any value)
3: 11.2
4: 5.70.152
Shalex wrote:Hannes, your letters were blocked by our e-mail system. Sorry for the inconvenience.
1. Please send me also the DDL/DML script for the database objects you are working with via data sources.
2. The exact steps we should follow to reproduce the ORA-01461 error.
3. The version of your Oracle Server.
4. Your current version of dotConnect for Oracle is 5.70.152 (Tools > Oracle > About), and you are using Direct Mode. Is this correct?
by hannes_a
Sat 09 Oct 2010 10:35
Forum: dotConnect for Oracle
Topic: ORA-01461 during update of CLOB in ASP
Replies: 13
Views: 122345

I sent you a mail on
03.09.2010 22:05 to support size 3,7M
07.09.2010 20:15 to alexsh size 3,7M
08.09.2010 22:24 to alexsh, alexh size 5k
without any response
by hannes_a
Fri 17 Sep 2010 07:15
Forum: dotConnect for Oracle
Topic: Error in dbMonitor 3.02
Replies: 15
Views: 2930

thank you !

the host option is very useful.

there is now download link in secure areal, but I was able to download in common download areal.

I see for my requested parm-out-copy-feature I've to wait till version 3.04
Anyway, I asked you several times, to add the capability to copy query paramter out of dbmonitor.
http://www.devart.com/forums/viewtopic.php?t=2890 2006 !
http://www.devart.com/forums/viewtopic.php?t=13299 2008

dbmonitor is very usefull tool, but I hope you will add this feature in 2010 to improve it
by hannes_a
Fri 03 Sep 2010 20:06
Forum: dotConnect for Oracle
Topic: ORA-01461 during update of CLOB in ASP
Replies: 13
Views: 122345

ORA-01461 during update of CLOB in ASP

during update of a CLOB column a
ORA-01461: can bind a LONG value only for insert into a LONG column
is raised, I sent you a test project
by hannes_a
Tue 10 Aug 2010 17:22
Forum: dotConnect for Oracle
Topic: OracleDataSource with CLOB raises ORA-01461
Replies: 2
Views: 1831

today it works with the same sourcecode.
please forget it

thank you

Go to advanced search