Missing Source Code in a Stored Procedure using Datagrip
2 人关注
Hello,
I created a new stored procedure on basis of an existing procedure but I am not able to see the code for newly created procedure---
-- auto-generated definition
create procedure dbo.getemployee(@pnRequestId binary(16), @pnEmployeeID smallint) as
-- missing source code
go
I am using below Datagrip version--
DataGrip 2024.1.3
Build #DB-241.17011.41, built on May 15, 2024
Runtime version: 17.0.11+1-b1207.23 amd64
VM: OpenJDK 64-Bit Server VM by JetBrains s.r.o.
Windows 10.0
GC: G1 Young Generation, G1 Old Generation
Memory: 4096M
Cores: 12
Registry:
ide.experimental.ui=true
请先登录再写评论。
I have tested a procedure with the same arguments by creating it in an MSSQL data source, but haven't experienced any issues when going to view the procedure definition in 2024.1.3. Can you provide more details if this happens to every procedure or if just one specific is involved? Have you attempted to refresh the schema and check the definition after?
It's a sybase db server which I am connecting. I can view the code for the stored procedures already present in the database.
But when I just copy the existing procedure and create a new one by giving it another name, it creates it but I cannot see any code within it as shown in the image earlier.
I did refreshed the schema multiple times and disconnected/connected again to the server but no luck.
There is already a comment I posted on similar issue. Please ignore that post. Please post comments in this post. Thanks
I tested the table definition on a sybase 15.7 data source +jtDs 1.3.1.1 jdbc driver + DataGrip 2024.2.2, and it returned the table definition without any issues. May I know what is your Sybase db version, IDE version and jdbc version? You may want to repeat this action using the same IDE and jdbc drivers I was using and let me know your results.